Connecting Tech Pros Worldwide Forums | Help | Site Map

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

_mario.lat
Guest
 
Posts: n/a
#1: Oct 14 '06
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.

Gleep
Guest
 
Posts: n/a
#2: Oct 14 '06

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


On Sat, 14 Oct 2006 13:32:02 +0200, "_mario.lat" <_mario.lat@libero.itwrote:
Quote:
>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
bob.chatman@gmail.com
Guest
 
Posts: n/a
#3: Oct 14 '06

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


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

IchBin
Guest
 
Posts: n/a
#4: Oct 14 '06

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


bob.chatman@gmail.com wrote:
Quote:
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-)
_mario.lat
Guest
 
Posts: n/a
#5: Oct 16 '06

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


Thank you to all!
It is what I'm looking for!
Quote:
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.
Closed Thread