*SQL-ish projects

Projects related to SQL in general (including MySQL and PostgreSQL)

I have CVS repository for SQL related tools at :pserver:anonymous@cvs.linux.hr:/cvsroot
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 www-sql2php 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 my2pg 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 pgsql2interbase that can convert PostgreSQL dump to Interbase.
• If you need to remap characters from PostgreSQL to some other codepage (for example when connecting via ODBC from Windows) you can use pg_recode . 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 toczs which uses translate (which is handy if you don't want to recompile pg_recode when you update your database).
• exportSQL is a Microsoft Access module which exports Access Database into MySQL, mSQL and PostgreSQL. It's based on work of Pedro Freire. [fm] [CVS]
  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 Conversion.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 ODBC? Try this operators which Access 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.
• re-init_pg.sh 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. [CVS]
• 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. [cvs]
• pgswish enables you to query swish-e from PostgreSQL. This allows integration of search results from swish-e index with structured data from PostgreSQL. [cvs]
• pgestraier 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. [cvs]