News for hackers. Stuff that matters.
Re:A Minimalist Guide to SQLite by danso on Wednesday November 01, 2017 @11:17PM (#15607561)
Very nice! I'm in the middle of writing a book based on SQLite (the overall topic is data analysis with SQL, but SQLite is the medium) while I'm teaching it to students. I used to teach MySQL but it was just so goddamned hard to get it configured correctly on people's computers (I always hated when work had to be done on pre-configured computers lab rather than my own laptop), nevermind the server/client/daemon aspects of MySQL and other variants. While SQLite lacks polished (and free) GUIs, it's easier to explain on a sysops level (with sqlite files being similar to XLS files) without burying students in irrelevant tech details on the way to learning the power of SQL queries.
Re:A Minimalist Guide to SQLite by Something1234 on Wednesday November 01, 2017 @11:36PM (#15607643)
Have you tried sqlitebrowser? It's fantastic, I use it a lot.

http://sqlitebrowser.org

Re:A Minimalist Guide to SQLite by danso on Thursday November 02, 2017 @08:14AM (#15609636)
Yep, that's what I use. Because it is open-source and cross-platform -- not to mention, pretty high quality -- it has significantly increased the attractiveness of teaching SQLite. Previously, me and other SQLite teachers I knew would point students to the SQLite Manager plugin for Firefox, which is also free and open source, but a bit clunkier: https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage...

The DB Browser (they changed it from sqlitebrowser at the request of sqlite IIRC) also has in my experience, a very helpful and responsive dev team: https://github.com/sqlitebrowser/sqlitebrowser/issues

Re:A Minimalist Guide to SQLite by justinclift on Friday November 03, 2017 @03:11PM (#15621555)
> ... also has in my experience, a very helpful and responsive dev team.

Thanks. We definitely try. :D

Re:A Minimalist Guide to SQLite by justinclift on Friday November 03, 2017 @03:13PM (#15621566)
Thank you. :)

(I'm one of the dev's on that project)

Re:A Minimalist Guide to SQLite by takeda on Thursday November 02, 2017 @02:11AM (#15608210)
I suppose you are using SQLite as a tool to teach analysis so this is probably not a big issue.

But I really disliked that my database teacher decided to use MySQL to teach about databases (that was about 10 years ago).

Several times he would talk about specific concept, then mention that MySQL doesn't have it (like CHECK constraint, enforcing foreign constraints, aborting statements through triggers (emulated by throwing exception) etc). If we are going to learn universal database concepts, why not use database that supports them. I personally learn things better when I can try runs out and see how they work.

Sorry for my rant, it just reminded me about that.

Re:A Minimalist Guide to SQLite by hexene on Thursday November 02, 2017 @12:32AM (#15607849)
I'm of course not suggesting you switch back to MySQL, but distributing preconfigured MySQL docker images perhaps might've helped with your configuration troubles.
Re:A Minimalist Guide to SQLite by throw2016 on Thursday November 02, 2017 @09:09AM (#15610041)
This kind of use docker comment is being left on most threads to do with setup issues.

So you are advocating people who have issues with simple apt-get or yum install mysql or <app> to instead install docker and deal with the complexity of docker, before they can use the app?

Re:A Minimalist Guide to SQLite by hexene on Monday November 06, 2017 @11:54PM (#15641157)
It really depends on the use-case, though I'll concede that docker would've been overkill for the parent based on their comment below.
Re:A Minimalist Guide to SQLite by danso on Thursday November 02, 2017 @06:58AM (#15609272)
Maybe now, but it didn't seem feasible in 2014, or at least I just wasn't familiar enough with it at that point. In any case, this was a humanities class, and I wanted to keep the tech as straightforward as possible.