Projects related to SQL in general (including MySQL and PostgreSQL)
I have CVS repository for SQL related tools at
Checkout module named sql to get
www-sql2php and mysql2pgsql.
- www-sql is a nice tool
to make database access easy from html. I liked it so much that I made
some patches against 0.5.7.
- However, it seems that www-sql isn't supported any more. So with
you can migrate your application to
PHP. It's alpha software -- some functions
are not implemented. But, since it's written in perl, feel free to contribute!
I successfully converted two projects to php, so it actually work...
- Perl script mysql2pgsql can be used to
convert MySQL database dump to
PostgreSQL-compatible format (for migration from MySQL to PostgreSQL).
New maintainer of this script is Joseph Speigle, so you should probably contact him about it, not me. Thanks, Joseph.
Similar project is
so if mysql2pgsql doesn't work for you try this one. It's included
in PostgreSQL contrib/mysql directory since PostgreSQL 7.1beta5, so it's
probably better peace of code :-).
- Another script
that can convert PostgreSQL dump to
- If you need to remap characters from
PostgreSQL to some other codepage (for example when connecting via ODBC
from Windows) you can use
It's a collection of C functions: to1250 - remaps iso8859-2 to cp1250,
toczs - replaces Croatia characters with czs equivalents,
to88592 - remaps cp1250 to iso8859-2,
initcap2 - initcap which works with iso8859-2 or cp1250.
There is also PlPgSql version of
translate (which is handy if you don't want to recompile pg_recode when you update your database).
Microsoft Access module which exports Access Database into MySQL, mSQL
and PostgreSQL. It's based on work of
There is also a GUI version, kindly donated by Marc Breneiser
<mbreneiser(at)whgrp(dot)com> which is especially useful if your
Access database is already converted to .mde files. Zip
includes .exe and source in VB.
- DBI for PHP
is a great way to program database-independent code in PHP.
So, I wrote Interbase
DBD module for it (included from version 0.3.6)
- Having problems with accessing PostgreSQL from Microsoft Access using
need and depends on. There are (mostly) not mine, just collected on Usenet.
- Usogres is Synchronizing
Option for PostgreSQL, and I have written paper
with benchmark about it.
is a little shell
script that will change encoding in your database. You can use it to add
locales to existing database. You have to set LC_* vars before you
run it under postgres account.
- You might be interested in cricket-modules
which can monitor PostgreSQL performance. They have
their own page.
RServ improved by community is my project, hosted at GBorg for improving RServ
replication available in PostgreSQL contrib. It will soon have separate page
on my site.
- pgdiff is extremely useful
script for postgresql users: it allows to diff two databases (possibly at
different hosts) and dumps sql to stdout which will transfer changes from
master to slave database. it's off-spin from rserv project mentioned above.
enables you to query swish-e
from PostgreSQL. This allows integration of search results from swish-e
index with structured data from PostgreSQL.
enables you to query
Hyper Estraier from PostgreSQL. This allows integration of search
results from Hyper Estraier full-text index with structured data from
PostgreSQL. This function is more mature than pgswish.