New database abstraction layer

[neoxed]

The upcoming release of AlcoBot, version 1.2, will feature a new database abstraction layer (DBAL) to replace ODBC. I dislike ODBC for many of the same reasons as the rest of you do, so I finally got off my ass and kicked it to the curb. ;)

This new DBAL specifies the database with a URI-style string:

Format:
scheme://user:password@host:port/database&option=value

Examples:
mysql://user:password@host:3306/alcoholicz
postgres://user:password@host:5432/alcoholicz
sqlite:C:/Eggdrop/AlcoBot/alcoholicz.db

Using SSL:
mysql://user:password@host:3306/alcoholicz&ssl=true
postgres://user:password@host:5432/alcoholicz&sslmode=require

So far, it only includes support for popular open-source databases: MySQL, PostgreSQL, and SQLite. Are there any other database servers you would like to see supported (e.g. Firebird or Oracle)?

[Freestyler]

Yes. Please add Microsoft SQL Server 2005 support.
Normally I'm not a big Microsoft supporter, but after working with several databases professionally for years it seems to be a very trustable, easy to maintain database.

[neoxed]

There's no Tcl extension to communicate directly with MS-SQL, to my knowledge anyway. So...it’s not really possible to support MS-SQL.

[eger]

I am very glad u added a direct mysql connection!! No more MySQL ODBC fumbling!!!