473,408 Members | 2,888 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

Pure Php Flat-File Databases?

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
5 4851
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Christopher Boomer | last post by:
Until now I have been using XSLT to translate from a known foreign XML format to a local XML format for import to Postgres. Now I need to be able to let others define the relationship from new...
11
by: Nicolas Girard | last post by:
Hi, Forgive me if the answer is trivial, but could you tell me how to achieve the following: {k1:,k2:v3,...} --> ,,,...] The subtle point (at least to me) is to "flatten" values that are...
699
by: mike420 | last post by:
I think everyone who used Python will agree that its syntax is the best thing going for it. It is very readable and easy for everyone to learn. But, Python does not a have very good macro...
11
by: santosh | last post by:
Hello, I was going through the Marshal Cline's C++ FAQ-Lite. I have a doubt regarding section 33.10. Here he is declaring a pure virtual destructor in the base class. And again defining...
7
by: Maileen | last post by:
Hi, I asked few days ago about a flat button control under VB.NET but answer didn't satisfy me. I know that a such button existed under VB6 so it should exist under VB.NET also. Where can...
5
by: AbdulGafoor GK | last post by:
hi i am using visual studio 2005. i could make combobox flat, but without border. is there any way to draw a border for it ?!!! thanks
10
by: John Goche | last post by:
Hello, page 202 of Symbian OS Explained by Jo Stichbury states "All virtual functions, public, protected or private, should be exported" then page 203 states "In the rare cases where a...
3
by: Jia Lu | last post by:
Hello all I see there are lots of flat db or db-like modules in the standard python modules. What about the keywords seeking speed of them ? (I want to put about 10000 articles with 10000...
14
by: Jack | last post by:
Hi, I meet a question with it , I did not get clear the different betteen them, for example: #include <iostream>
5
FishVal
by: FishVal | last post by:
IMHO, the following is not a how-to-do instruction to solve a particular problem but more a concept-proof stuff demonstrating possibilities of SQL. So, let us say the problem is to calculate...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.