SQLite: Data entry interface?

6

2

I'd to like to use SQLite to start tracking a few things. I won't have any trouble setting up the database itself, but I'd struggle at programming an interface.

Is there any kind of open source data entry interface to SQLite? (not just 'click-and-edit' table views').

Tommy O'Dell

Posted 2011-04-02T23:05:48.073

Reputation: 213

Answers

3

Look at SQLite Database Browser. Contrary to it's name, it can also create and edit databases and tabless.

enter image description here

Sathyajith Bhat

Posted 2011-04-02T23:05:48.073

Reputation: 58 436

It looks interesting, but it's not exactly what I'm looking for. I'm not just looking to be able to edit a table. I want to be able to make meaningful entries into a schema that might require updating 3-4 linked tables with each new "entry". – Tommy O'Dell – 2011-04-03T06:59:58.073

2

OpenOffice Base can use SQLite as a backend, as can Kexi on Linux. (Apparently it's possible to build Kexi on Windows, but I couldn't find any free-as-in-beer Windows binaries after a cursory search.)

user55325

Posted 2011-04-02T23:05:48.073

Reputation: 4 693

1

I'm not sure if this is for a web server or not, but if you're running PHP, there is phpLiteAdmin, which is free and comparable to phpMyAdmin for mySQL.

Chris Sobolewski

Posted 2011-04-02T23:05:48.073

Reputation: 613