Go Back   FlashFXP Forums > > > >

NeoXed's scripts nxAutoNuke, nxTools, etc.

Reply
 
Thread Tools Rate Thread Display Modes
Old 04-30-2006, 11:08 PM   #1
neoxed
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: May 2003
Posts: 1,326
Default 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)?
neoxed is offline   Reply With Quote
Old 05-04-2006, 05:20 PM   #2
Freestyler
Junior Member
ioFTPD Registered User
 
Join Date: Nov 2003
Posts: 19
Default

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.
Freestyler is offline   Reply With Quote
Old 05-04-2006, 06:13 PM   #3
neoxed
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: May 2003
Posts: 1,326
Default

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.
neoxed is offline   Reply With Quote
Old 05-18-2006, 08:45 PM   #4
eger
Member
FlashFXP Beta Tester
ioFTPD Foundation User
 
Join Date: Mar 2003
Posts: 40
Default

I am very glad u added a direct mysql connection!! No more MySQL ODBC fumbling!!!
eger is offline   Reply With Quote
Reply

Tags
abstraction, database, dbal, layer, odbc

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 09:00 AM.

Parts of this site powered by vBulletin Mods & Addons from DragonByte Technologies Ltd. (Details)