Stephen Chrzanowski <pontia...@gmail.com> wrote:
>
> I know you said you didn't want a DBMS, but really, when you're saying
> you're willing to write an application to manage the data, you're writing a
> DBMS. Save time, don't reinvent the wheel unless you're going on a
> learning adventure.
>
I don't want to load/use a DBMS *when I'm editing the data*. Of course
a database management program is an excellent tool for managing the
database, but they're generally rubbish at making it easy to enter data
into the database.
There are two quite separate and distinct requirements when using
databases:-
A way to create the database, handle relationships, column types,
backups, etc. For this there seems to be lots of choice, I
personally use a mix of the command-line sqlite3 and sqlitebrowser
and sqliteman.
A way for users (mostly me in my case, but also sometimes other
people) to enter data into the database. There don't seem to be
many good tools for doing this. In particular there seems to be
very little that does a straightforward datagrid given the name of
the database and table to open.
OK, in many cases designing a form for data entry makes sense and there
are tools for this (kexi comes to mind, though as I said earlier it has
significant limitations). If I wanted to have a nice form to enter a
single record without being able to see the rest of the data I could
fairly easily get what I want. However getting a grid view for data
entry where I can see the other records (often *very* useful) is a lot
more difficult.
Having to wade through the layers of a DBMS tool when all I want to do
is add one row of data to my table is painful. This particular
application involves adding one row of data maybe once every ten days or
so. Thus I want a quick 'click here and type in the row of data' type
approach and don't want to have to load a heavyweight application and
wade through a load of menus just to type in what is essentially a
single line of text.
--
Chris Green
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
