txtSQL and flatfile


Joined: 2005-01-02
Posts: 1
Posted: Sun, 2005-01-02 20:54

This might have been mentioned before somewhere on the forums, but I can't seem to be able to locate it...

I would reccommend using txtSQL in your gallery program. There are several reasons for this...
- txtSQL offers speed uncomparable by other flatfiles systems
- Reliability and security of files
- Use of functions in queries
- Can be used on any system using PHP
- SQL syntax is being developed
- The revision and editing of data is simple through txtSQLAdmin
- Released under the GPL
- Advanced error reporting
- Enables easy linking of rows in several tables
- and much more

txtSQL is located at http://txtsql.sf.net

Thank you for your time,
Faraz Ali

signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Sun, 2005-01-02 22:38

Gallery 1 is not going to be using SQL of any kind, however Gallery 2 is already fully SQL capable.


Joined: 2005-12-12
Posts: 1
Posted: Mon, 2005-12-12 01:23

Will or is GAllery 2 capable of running with fully functionality off of textSQL?
This would be very helpfull for me as I am stuck with cheap hosting without a SQLdb and need a flatfile system but would like the templating and other features of Gallery2


Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2005-12-13 02:35

g2 only supports mysql, postgresql, oracle and db2 right now.
we plan to add php sqLite support (php 5 built in flat file database). but it won't be easy and it doesn't have a a very high priority right now.

in the development version of g2, we just removed an abstraction layer that allowed for non database storage implementations. we removed it since it doesn't make any sense anymore to use a non-sql backend for g2.
but something like an SQL based flat file database like sqLite makes sense.


Joined: 2007-02-17
Posts: 1
Posted: Sat, 2007-02-17 12:19

valiant, I have something really important to tell you: the keyword is Gladius DB.

It has an ADODB API, it works with SQL92 and it is fast, too! It would be great if you could consider its usage in g2. At the moment it also has an adoDB lite driver, so that using any database is possible along with it.