SQLite

[tg12]

Hi all,

 

Saw recent thread about MySQL but I'm looking for more info on SQLite as I've been told by our ICT teachers that they now need it for various courses. Of course, I don't really know much about it and, as always with these things, the only thing I really get given by the teachers is the instruction to do it because "It's the recommended version for schools as it's free to use" [Citation needed!] and a time of when they expect it done by.

 

From what I've seen so far, it all looks to be self-contained exes. Regarding security, is there anything I should look out for, or is it fairly harmless to allow it to run for students?

 

Thanks!

[Ditto]

Hi @tg12. As an ex-development manager within IBM on a predictive analytics product, I had an extremely capable and trust-worthy technical lead. He recommended a switch from MySQL to SQLite. Knowing the rigours around compliance with IBM, I'm confident it's safe to use. From memory, it was small, fast and reliabel. What I'm not sure about about, it how simple it is to use - it could be command line only.

 

What years group(s) are we talking about and what are the learning objectives? If simple, you might want to consider something as light weight, but accessible as https://www.w3schools.com/sql/ or if you are going push towards industry practice, you can even go for a full oracle route and look at Oracle SQL Developer. Historically their licenses allowed non-commercial use, but you'd need to check that.

[jinnantonnixx]

I'm a big fan of SQLite. They are self contained databases files - not exes. They don't need a server, which removes the headaches of security, permissions and db user problems.

Furthermore, SQLite is everywhere - from watches to supercomputers; it's the most widely used database out there, so it's a great way to learn SQL.

 

The kids can take the SQLite database file and work on it anywhere.

 

Here's a great trick - if you use Firefox, there's a rather nice add-on which gives you graphical management of SQLite databases. It's as good as any manager. Running from Firefox, it's also device independent.

https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

 

Overview of SQLite language structure.

https://www.sqlite.org/lang.html

 

 

More of my ravings here:

http://www.edugeek.net/forums/windows-7/154055-sql-training-infrastructure.html#post1321188

Edited March 17, 2017 by jinnantonnixx

[dhicks]

From what I've seen so far, it all looks to be self-contained exes.

 

Not quite - SQLite is designed to be compiled into a language compiler / interpetor, so tends to come included in other languages. For instance, in Python just do "import sqlite3" at the top of the file and away you go.

[tg12]

Thanks guys, sounds reassuring that it isn't too much hard work for me!

 

As for exe files, I think I threw everyone off by forgetting to mention that these are the downloadable SQL tools from the SQLite website, sorry!