CODEWITHSUNDEEP
sqlite
Webiter
Webiter

Reputation: 119

Starting with SQLite

Have just downloaded SQLite amalgamation 3070900 as I wish to develop some experience in SQLite databases.

I have managed to get it out of the box. Where to now! How do I get the engine to start! How best should I commence so as to get some practice things going with the SQLite package? Cannot find much basic stuff on the web.

Upvotes: 0

Views: 679

Answers (2)

memilanuk
memilanuk

Reputation: 3542

There are a bunch of video tutorials for SQLite on YouTube... I particularly recommend the ones by Jay Godse, aka 'jaynonymous1'. The very first one is a little rough; later epsiodes explore specific features like autoincrement, unions, joins, foreign keys, check constraints, etc. as well as some basic usage under a few different programming languages (Python, Lua, etc.)

Upvotes: 0

Larry Lustig
Larry Lustig

Reputation: 50970

SQLite is an embedded database, it has no "engine" per se. It's implemented as a single loadable library (a DLL on windows). You do not need the C source code, which is what you appear to have downloaded, to use it.

SQLite itself has no user interface nor any way for you to interact with it directly. There is a very simple command-line interface program available for most (all?) platforms, however, called sqlite3 (sqlite3.exe on Windows). With that program you can create and work with databases. You might find it easier, however, to use one of the many GUI SQLite manager programs available on the web.

To program against the SQLite database you will need to choose a programming language and make sure you have the correct SQLite interface libraries.

Upvotes: 4

Related Questions