vpSQL is a small set of functions (under 13k)┬ that interacts with a flat file database through a subset of sql instructions.
vpSQL accepts the the following sql statements:
SELECT┬ fields┬ FROM table[WHERE][ORDER BY][lLIMIT]
INSERT┬ fields,data┬ INTO table
UPDATE┬ table fields/data WHERE
DELETE┬ from table┬ WHERE┬
Features of vpSQL
- An autoinc field named vpid which is transparently created with each table. This gives the advantage of having a unique field for searches.
- Uses character substitution for semi colons and linefeeds which allows you to store full page texts.
- It is small and uses only one file which can be included anywhere in your script.
The functions mimic php mysql functions so they are scalable. This is a new script and is essentialy beta so I am anxious to have some input on it. I have set up a forum where you can give me feedback. For more information take a look at the docs here.┬ You can also see vpSQL used as a backend to a Virtual pages site here.
You can download the source and docs