I was going through the SQLiteBooks sample code downloaded from Apple. I understand everything about the example except how they created the initial database that is used in the project (booksdb.sql).

Is there a built-in application on the Mac to create a database, kinda like Enterprise Manager on Windows?

Thanks in advance.

Mac OS X ships with a command-line interface to SQLite. man sqlite3

I used this:
http://sourceforge.net/projects/sqlitebrowser/

It had a few quirks, but not bad.

smasher Wrote:I used this:
http://sourceforge.net/projects/sqlitebrowser/

It had a few quirks, but not bad.

I tried the SQLiteBrowser, it got the job done for me to create a very simple DB to play with. I think I will install mySQL because I need more functionality, for example, setting default values for columns or creating restraints.

Thanks for the help