Home > Archive > PHP Language > October 2006 > dealing data in a file as in a db (with sql). How?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
dealing data in a file as in a db (with sql). How?
|
|
| _mario.lat 2006-10-14, 7:56 am |
| 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-Develop...2536834?ie=UTF8
or type luke welling php in searchs
| |
| bob.chatman@gmail.com 2006-10-14, 6:56 pm |
| 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 2006-10-14, 6:56 pm |
| 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-)
| |
| _mario.lat 2006-10-16, 6:56 pm |
| 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.
| |
|
| 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.
I have an amazing article for a flat file db using php check it out
http://www.php-editors.com/articles/php_textfile.php
| |
| Such Skywalker 2006-10-17, 6:56 pm |
| what about SQLite? you work SQL-like and all the data is stored in one
single file.
| |
| _mario.lat 2006-10-18, 6:57 pm |
| On Tue, 17 Oct 2006 15:28:23 -0700, Such Skywalker wrote:
> what about SQLite? you work SQL-like and all the data is stored in one
> single file.
No... I'm looking for...
Where I can find something good.
|
|
|
|
|