Am Donnerstag, 7. Juni 2007 19:49 schrieb Tim Anderson:
> I'm writing an article about SQLite and I'd love to get some comments
>
> >from users about why you use it. Performance? Features? Reliability?
>
> Cost? Is the open source aspect important? Anything else? For that
> matter, anything you really don't like about SQLite?
>
I prefer SQLite as for applications where a substancial amount of information
otherwise would be stored in made-up-from-scratch file formats. As soon as you
need more structure than key-value pairs, an SQL database comes in handy.
It's pretty easy to extend an application with a SQLite db backend. You don't
have to run a database server process just for storing some tables.
What I especially like about SQLite is it's Tcl language binding. We do a lot
of programming and scripting in Tcl and SQLite's Tcl interface handles the
variable quoting automatically, so SQL injection bugs are very unlikely to
happen.
The ability to extend SQLite's features -- e.g. adding custom collation
sequences -- easily is another ++ for me.
> You can email me at tim(at)itwriting.com or comment here if you prefer -
> but to use your quote I'd need at least a full name, what you do and the
> company you work for
>
My company TuxTAP develops and manufactures Linux based cash registers and
electronic dispensers for restaurants.
Kind regards
Jan
--
The first law of demos:
- never try to actually use the system for anything
