By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,457 Members | 1,294 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,457 IT Pros & Developers. It's quick & easy.

Pure Php Flat-File Databases?

P: n/a
I've writing my own flat file database.. well table-based pure php
code, PhpSimpleDb but I was looking into some bench marking so was
wonder if anyone knew any other flat-file php db's out there.

Gladius DB
txtSQL

ps. http://code.google.com/p/phpsimpledb/ is what I have working right
now.
Jun 27 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Wed, 04 Jun 2008 02:00:35 +0200, Gorilla3D <su****@gmail.comwrote:
I've writing my own flat file database.. well table-based pure php
code, PhpSimpleDb but I was looking into some bench marking so was
wonder if anyone knew any other flat-file php db's out there.

Gladius DB
txtSQL

ps. http://code.google.com/p/phpsimpledb/ is what I have working right
now.
Any reason to compete with SQLite? I found that is was enabled on most
servers...
--
Rik Wasmus
....spamrun finished
Jun 27 '08 #2

P: n/a
Well, SQLite uses SQL, I was just looking to to use pure php to query
rather then SQL. Which is why I considered writing my own. I am in no
way trying to compete with SQLite in the sense of a full fledge
database, just something simple for php using php.

Sample MySQL
$link = mysql_connect('localhost', 'username', 'password');
$table = mysql_select_db('sampledb');
$query = mysql_query('SELECT * t1 WHERE c LIKE "%thousand%"');
$entry = mysql_fetch_assoc($query);

Sample SimpleDb
$t = new t1('data');
$rows = $t->filter('stristr(c, "thousand")')->query();
$idx = array_shift($rows);
$entry = $t->fetch($idx);

On Jun 3, 5:01 pm, "Rik Wasmus" <luiheidsgoe...@hotmail.comwrote:
On Wed, 04 Jun 2008 02:00:35 +0200, Gorilla3D <sut...@gmail.comwrote:
I've writing my own flat file database.. well table-based pure php
code, PhpSimpleDb but I was looking into some bench marking so was
wonder if anyone knew any other flat-file php db's out there.
Gladius DB
txtSQL
ps.http://code.google.com/p/phpsimpledb/is what I have working right
now.

Any reason to compete with SQLite? I found that is was enabled on most
servers...
--
Rik Wasmus
...spamrun finished
Jun 27 '08 #3

P: n/a
Gorilla3D wrote:
Well, SQLite uses SQL, I was just looking to to use pure php to query
rather then SQL. Which is why I considered writing my own. I am in no
way trying to compete with SQLite in the sense of a full fledge
database, just something simple for php using php.

Sample MySQL
$link = mysql_connect('localhost', 'username', 'password');
$table = mysql_select_db('sampledb');
$query = mysql_query('SELECT * t1 WHERE c LIKE "%thousand%"');
$entry = mysql_fetch_assoc($query);

Sample SimpleDb
$t = new t1('data');
$rows = $t->filter('stristr(c, "thousand")')->query();
$idx = array_shift($rows);
$entry = $t->fetch($idx);

On Jun 3, 5:01 pm, "Rik Wasmus" <luiheidsgoe...@hotmail.comwrote:
>On Wed, 04 Jun 2008 02:00:35 +0200, Gorilla3D <sut...@gmail.comwrote:
>>I've writing my own flat file database.. well table-based pure php
code, PhpSimpleDb but I was looking into some bench marking so was
wonder if anyone knew any other flat-file php db's out there.
Gladius DB
txtSQL
ps.http://code.google.com/p/phpsimpledb/is what I have working right
now.
Any reason to compete with SQLite? I found that is was enabled on most
servers...
--
Rik Wasmus
...spamrun finished
I think you'll find SQLLite or MySQL will outperform anything you write
in PHP, unless it's for very small files.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jun 27 '08 #4

P: n/a
Gorilla3D schreef:
I've writing my own flat file database.. well table-based pure php
code, PhpSimpleDb but I was looking into some bench marking so was
wonder if anyone knew any other flat-file php db's out there.

Gladius DB
txtSQL

ps. http://code.google.com/p/phpsimpledb/ is what I have working right
now.
Hi,

I used a few in the past, with different results.
In these days almost every server running PHP also runs at least mySQL,
or if you are really lucky: Postgresql.

Here is a link to a reasonably wellknown flatfile engine: ffdb (flat
file db):
http://sourceforge.net/projects/ffdb-php/

You can use that one for benchmarking.

I don't want to be negative, but the flatfile approach is needed less
and less. So unless you are doing this for pure fun, I don't expect many
will need it.

Good luck!

Regards,
Erwin Moller

PS: I wanted to give you more links, but in all honesty, I plainly
forgot the names of the other flat file SQL engines I used. :-)
I know there a few more out there.
Jun 27 '08 #5

P: n/a
On Jun 4, 3:00*am, Gorilla3D <sut...@gmail.comwrote:
I've writing my own flat file database.. well table-based pure php
code, PhpSimpleDb but I was looking into some bench marking so was
wonder if anyone knew any other flat-file php db's out there.

Gladius DB
txtSQL

ps.http://code.google.com/p/phpsimpledb/is what I have working right
now.
By the way i use SQLite on my usb-sticks, where i store my sites as
portable back-ups, run hp from stick from my customized apache-lite,
its really handy.. I use to used flat files but, i think SQLite is the
best.
Jun 27 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.