dealing data in a file as in a db (with sql). How?

Hallo,
I have read about dealing data in a file with sql.
I mean to use some function to insert, select, modify data in a simple
file as a db (with sql).
Which library let that?
Thank you in advance,
Mario.

On Sat, 14 Oct 2006 13:32:02 +0200, "_mario.lat" <_mario.lat@libero.it> wrote:

>Hallo,
>I have read about dealing data in a file with sql.
>I mean to use some function to insert, select, modify data in a simple
>file as a db (with sql).
>Which library let that?
>Thank you in advance,
>Mario.


You need to go to a book store and get a decent book on PHP/MySQL and start reading. Here is what I
started out with.
http://www.amazon.com/MySQL-Developm...536834?ie=UTF8

or type luke welling php in searchs

I think he wants to treat a flat file as a mysql database. If you are
serious about it i would suggest you look up hashing to disk. I dont
know of any ways to treat a flat file like a database in PHP, only perl
with CSV. You would have to create any functionality.

I have only delt with flat files if i know it wont get too long, mainly
because searching is a pain in the butt, ordering helps but not if you
are going to sort by multiple fields.

In order to help out a bit, let us know what you are actually trying to
do, your goal. That would help us get the ball rolling and better help
you out.

Bob

bob.chatman@gmail.com wrote:
> I think he wants to treat a flat file as a mysql database. If you are
> serious about it i would suggest you look up hashing to disk. I dont
> know of any ways to treat a flat file like a database in PHP, only perl
> with CSV. You would have to create any functionality.
>
> I have only delt with flat files if i know it wont get too long, mainly
> because searching is a pain in the butt, ordering helps but not if you
> are going to sort by multiple fields.
>
> In order to help out a bit, let us know what you are actually trying to
> do, your goal. That would help us get the ball rolling and better help
> you out.
>
> Bob
>
A flat file database that has been around a long time is Berkeley
database. You can select between a C\C++ or Java driven database. For
years it was the product of Sleepycat but Big Brother owns it now at Oracle.

http://www.oracle.com/database/berkeley-db/index.html

Another one that that is newer is a C based DB called SQLite.
http://pecl.php.net/package/SQLite

You will not have any problems searching these database because they
support SQL.

--
Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
__________________________________________________ ________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Thank you to all!
It is what I'm looking for!

> A flat file database that has been around a long time is Berkeley
> database. You can select between a C\C++ or Java driven database. For
> years it was the product of Sleepycat but Big Brother owns it now at Oracle.
>
> http://www.oracle.com/database/berkeley-db/index.html
>
> Another one that that is newer is a C based DB called SQLite.
> http://pecl.php.net/package/SQLite
>
> You will not have any problems searching these database because they
> support SQL.