Re: Ada DB bindings and APQ

[Brian May <bam@snoopy.apana.org.au>]

>>>>> "Warren" == Warren W Gay VE3WWG <ve3wwg@NoSpam.cogeco.ca> writes:

    Warren> I'm not against the "factory" idea, but i don't think it
    Warren> will prove to be very practical. The problem is that every
    Warren> database vendor has its own unique way of identifying
    Warren> users to the database. PostgreSQL is perhaps the strangest
    Warren> of them all, and they all overlap, but none of them agree
    Warren> on the required set of parameters. You can possibly make
    Warren> them agree in some situations, but this doesn't address
    Warren> existing databases well.

The solution here is to use a notation for identifying the database
that will work for all database.

I have to say I really like the PHP pear URL like syntax, copied from:

<URL:http://pear.php.net/manual/en/package.database.db.intro-dsn.php>

Example 26-1. Connect to database through a socket

mysql://user@unix(/path/to/socket)/pear

Example 26-2. Connect to database on a non standard port

pgsql://user:pass@tcp(localhost:5555)/pear

Example 26-3. Connect to SQLite on a Unix machine using options

sqlite:////full/unix/path/to/file.db?mode=0666

Example 26-4. Connect to SQLite on a Windows machine using options

sqlite:///c:/full/windows/path/to/file.db?mode=0666

Example 26-5. Connect to MySQLi using SSL

mysqli://user:pass@localhost/pear?key=client-key.pem&cert=client-cert.pem

Example 26-6. Connecting to MS Access sometimes requires admin as the user name

odbc(access)://admin@/datasourcename

Example 26-7. Connecting to ODBC with a specific cursor

odbc(access)://admin@/datasourcename?cursor=SQL_CUR_USE_ODBC

pgsql://someuser:apasswd@localhost/thedb

I think this is rather important as it would mean you don't need to
recompile the application in order to use a different database. It
also means the code doesn't have to explicitly support connecting to
every possible database that APQ supports.

Instead you just need *one* config option "database_url" that contains
the URL as per one of the above format.

If you want sample code to pass the URL, it is already written, it
just needs to be ported from PHP to Ada... Not sure how easy this will
be.
-- 
Brian May <bam@snoopy.apana.org.au>