?

Log in

No account? Create an account

Random thought on SQLite - Journal of Omnifarious

Sep. 1st, 2008

01:22 am - Random thought on SQLite

Previous Entry Share Next Entry

SQLite is the Unixey equivalent of Microsoft Access. A cheap, simple database for random use. Of course, it has no fancy GUI or integration with Visual Basic to make fancy forms or anything like that. It just does SQL, and does it reliably and well within its problem domain.

So, now I have an answer for some people who want to use Microsoft Access. It would be nice if someone built a VB like tool to sit on top of SQLite, then it would be a complete replacement. SQLite is certainly a great way to play with SQL without having to go through the administrative pain of setting up a database with a normal piece of database software designed for a much heavier load.

Edit 08:56 PDT: I didn't do the research I ought to have. There are apparently a whole bunch of SQLite GUIs. I don't know if any of them do as much as MS Access does, but I suspect at least one of them will actually be nicer to use for a beginner than the command line is.

The SQLite website has a list of SQLite GUI and/or management tools.


As a random aside, my stupid desktop system locked when I tried to send the new xcode I'd downloaded from Apple over to my laptop. It has a hardware/firmware issue on the motherboard that causes it to lock up when disk access occurs during heavy network usage, heavy usually meaning high speed transfers within my gigabit network. This is a probabilistic problem though, so if I use bittorrent or gnutella on that system it will likely eventually freeze, though it will take hours.

Current Location: 2237 NW 62nd ST, 98107
Current Mood: [mood icon] tired

Comments:

From:manuzhai
Date:September 1st, 2008 09:45 am (UTC)
(Link)
Ohh, a potent SQLite GUI (based on the Mozilla platform, for example) would rock...
(Reply) (Thread)
From:(Anonymous)
Date:September 1st, 2008 10:11 am (UTC)

Kexi?

(Link)
There are lots of GUIs for SQLite available. One quite featureful is KDE's Kexi. Have you evaluated it?

--ptman <http://paul.totterman.name/>
(Reply) (Thread)
From:rosencrantz319
Date:September 2nd, 2008 03:31 pm (UTC)
(Link)
(Reply) (Thread)
[User Picture]
From:omnifarious
Date:September 3rd, 2008 05:43 am (UTC)
(Link)

*chuckle*

(Reply) (Parent) (Thread)
[User Picture]
From:sparklewench
Date:September 2nd, 2008 05:37 pm (UTC)
(Link)
I'd like to hear more about how I can use a free database. Specifically finding the right thing, what I need, and how to get all the parts to make it work. seriously! post more! more details!
(Reply) (Thread)
[User Picture]
From:omnifarious
Date:September 3rd, 2008 05:44 am (UTC)
(Link)

Well, what do you want to use it for?

(Reply) (Parent) (Thread)
[User Picture]
From:sparklewench
Date:September 3rd, 2008 05:52 am (UTC)
(Link)
mostly people. I'd like to be able to write a lot about what they are doing, as well as where they work/worked, how I met them, directions to their locations, etc. I am interested in an interdisciplinary field and it would be very helpful for my memory to be supplemented by computer assistance. Seems like a solved problem, but I didn't find anything free or easy.
command line interface is fine with me. I'd like to to run on a mac since I have some now, but I have an old XP laptop I could convert (alternative being to buy a copy of XP). Or, I have a sick linux server that could be potentially used but probably only on a LAN not on a network.
(Reply) (Parent) (Thread)
[User Picture]
From:akashayi
Date:September 2nd, 2008 07:32 pm (UTC)
(Link)
I haven't actually used SQLite before, though I really should. ^^;
Usually just use mysql(and from the command line) for database stuffs.
(Reply) (Thread)