@garcle, woohoo!, gui's for a Mac user, thanks, I didn't know about them. sqliteexpert isn't available for OS X. Your other link helped. I downloaded free SQLiteStudio which seems easy enough for a (adjectives deleted) Mac user such as myself to use to get me started.
@anyone, I have some newbie questions.
1. On OSX 10.6.6 on a 2 year old intel mac, does it matter if I use 32 bit or 64 bit apps? I gather 64 bit is better but really don't understand why.
2. Re SQLite, if I want to create my own DBs, can I do it with the SQLite that's part of the calibre install, or do I need to DL another copy of SQLite, or set up something so the one instance can deal with multiple different DBs simultaneously? What solution would not interfere with calibre?
3. Re my noobness with unix system admin and Mac OS X unix in specific. Can anyone recommend any good books or web sites for me to learn from? (I had many problems trying to install MySQL (and then PostgreSQL) last night until I stopped when I realized I'd better learn what I'm doing first.)
4. Re MySQL or PostgreSQL, I got also got confused about using the server version vs using the non-server version. (I assume I don't need both.) I'm a hobbyist, not an enterprise. Any help for my confusion?
|