Looking for a 'grid' data entry tool for sqlite (or maybe mysql)

[Steve Flynn]

On 18 January 2012 11:06, Chris Green <cl at isbd.net> wrote:
> On Wed, Jan 18, 2012 at 12:28:18AM +0000, Steve Flynn wrote:
>> On 17 January 2012 18:00, Chris Green <cl at isbd.net> wrote:
>> > I'm after an application which will allow me to enter data into a sqlite
>> > database using a 'grid' layout of the data.  I.e. I want the existing
>> > contents of the database displayed as a table and I want to be able to
>> > click on a field in a row and just edit the data in place.  In addition
>> > I want to be able to use the TAB key to move from field to field
>> > (another key would be OK, just not the mouse).  There should be an empty
>> > row at the bottom for entering a new row.
>>
>>
>> SQL Developer should fit the bill for you. RPM's available from
>> http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
>>
>> We use it for our Oracle databases, but as it has ODBC capability you
>> should be able to point it at pretty much any compliant database
>> system.
>>
> I think that is just a *huge* (there's 147Mb of it) tool for doing
> database management.  I've looked at the overview and documentation and
> it has all the usual stuff for creating databases, importing data,
> building queries, etc.  but nothing for *editing* the data once in the
> table.  I guess one would call what I want 'forms'.  The first paragraph
> of "What is SQL Developer" says:-

It's huge because it's written in Java and has a lot of feature you
won't have any use for. It also probably contains a full
implementation of the java VM which you may or may not need/want

>    Oracle SQL Developer is a free graphical tool for database development.
>    With SQL Developer, you can browse database objects, run SQL statements
>    and SQL scripts, and edit and debug PL/SQL statements. You can also run
>    any number of provided reports, as well as create and save your own. SQL
>    Developer enhances productivity and simplifies your database development tasks.
>
> A brilliant list of all the things I don't want!  :-)   I don't want
> something to design/create my database, I already have the database.  I
> don't want to run complex queries on the data so SQL editors and
> debuggers are irrelevant.  I don't want to create reports.  I just want
> a straightforward way to enter data into my database.

I'm using it right now to edit some data in a table in our of our
databases. It has a grid layout, as you requested. Obviously it has a
load of stuff you don't need, such as a query builder, DDL editor and
so forth, but it will allow you to import data from text files, paste
data into a grid layout (moving from cell to cell just as you would
with a spreadsheet) or just type directly into a cell.

I'm pretty sure that something like toad, PL/SQL Developer or a myriad
of other tools will permit you to do the same thing, but they are
either proprietary, require licensing or don't run under Linux. This
product is free, will do what you want (I believe) and has a Linux
version.

Give it a whirl - if it's not what you need, you've lost precisely
what you paid for it - nothing.

-- 
Steve

When one person suffers from a delusion it is insanity. When many
people suffer from a delusion it is called religion.