[Tfug] Simple SQL database

[keith smith]

I like to standardize everything if possible.  My first choice would be MySql unless you have some special requirement that would dictate another DB.  Just makes life so much easier.  

Also you might want to look at MVC so your data code is separate from your code so that if you do decide to use multiple DB's you can easily convert if the need arises.  

I converted a big chunk of code to MVC and it is now much easier to maintain and upgrade.

------------------------
Keith Smith


--- On Thu, 1/21/10, Nathan England <nathan at paysonlinux.org> wrote:

> From: Nathan England <nathan at paysonlinux.org>
> Subject: [Tfug] Simple SQL database
> To: "Tucson Free Unix Group" <tfug at tfug.org>
> Date: Thursday, January 21, 2010, 3:06 PM
> 
> 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
> 
> _______________________________________________
> Tucson Free Unix Group - tfug at tfug.org
> Subscription Options:
> http://www.tfug.org/mailman/listinfo/tfug_tfug.org
>