[Tfug] Simple SQL database

[Jeff Breadner]

Nathan England wrote:
> Hello Hello,
>
> I am starting a new project and will be doing lots of command line bashing... 
> I am in need of a simple database and don't need the hefty requirements of 
> mysql, so I wanted to get some ideas or opinions on what to use. I have not 
> used sqlite in the past, so I'm not sure if that will do what I want. 
>
> My requires,
>
> typical sql syntax
> easily scriptable 
> can possibly be accessed using php in the future
>
> This list should not be hard to fit with something. I do not expect the 
> database to ever get anything larger than tiny, if you know what I mean.
> Currently I am using text files and pulling fields out of the text files. My 
> whole project is (hopefully) realize the speed difference between pulling 
> information from text files and pulling it from a sql database.
>
> What would you use for a simple sql database with bash scripts?
>
> nathan
>
>   
I've looked into this before and AFIAK sqlite is the best and perhaps 
only database that meets your criteria.  It is a very capable database 
with good SQL syntax support, in a very small package. 

For my project, it moved beyond it's original boundaries and we migrated 
to mySQL, but if your app is coded up right then if you make a similar 
migration down the road, it should just be a matter of changing your 
database connection properties if you're using something like PHP (we're 
using Rails).

cheers
  Jeff