FlashFXP Forums - View Single Post

neoxed · 04-30-2006, 11:08 PM

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:

Code:

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)?

04-30-2006, 11:08 PM
neoxed Too much time... Join Date: May 2003 Posts: 1,326	New database abstraction layer 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: Code: 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)?