4 ms·

Note: http://postgresapp.com/ http://postgresapp.com/ is trivial to install, although it only works on macs, is still more involved than a file, etc etc...

danso 10y ago
The one thing missing from SQLite is stronger type casting...however, SQLite does have a solid, cross-platform GUI in DB Browser [0]. It's not as nice as Sequel Pro and some of the commercial clients for MySQL. Postgres, unfortunately, doesn't have near the variety of reliable clients that MySQL and SQLite do. However, SQLite follows most of the standard syntax that Postgres does, so having students move right into CartoDB, which lets you run raw Postgres, has never been a problem.its just the self hosting that's a pain :). One more thing that I wish I could have from Postgres as a teacher: how it returns an error when you include non-aggregated columns in the SELECT clause. In MySQL and SQLite, selecting extra columns won't throw an error, and the results look close enough to correct to be fairly dangerous for novices. Better to just throw an error as Postgres does. [0] http://sqlitebrowser.org/ http://sqlitebrowser.org/
- placebo 10y ago
  Another good cross-platform GUI for SQLite that I've been using for years is TkSQLite (http://reddog.s35.xrea.com/wiki/TkSQLite.html http://reddog.s35.xrea.com/wiki/TkSQLite.html)
- elchief 10y ago
  Sqlite was a postgres fork, off of 8.something, IIRC
  - yoo1I 10y ago
    No. This is incorrect.
  - pmontra 10y ago
    It owes something to PostgreSQL but it's the syntax, not the source code. I quote from https://en.wikipedia.org/wiki/SQLite#History https://en.wikipedia.org/wiki/SQLite#History Hipp based the syntax and semantics on those of PostgreSQL 6.5. In August 2000, version 1.0 of SQLite was released, with storage based on gdbm (GNU Database Manager).
  - elchief 10y ago
    According to these slides from Sqlite founder, Sqlite was a "spin-off" of Postgres: http://www.pgcon.org/2014/schedule/attachments/319_PGCon2014OpeningKeynote.pdf http://www.pgcon.org/2014/schedule/attachments/319_PGCon2014... According to this, "SQLite was originally written from PostgreSQL 6.5 documentation" https://www.pgcon.org/2014/schedule/events/736.en.html https://www.pgcon.org/2014/schedule/events/736.en.html So, "fork" wasn't the right word. Apologies.
- googie 10y ago
  Yet another free, open source and multiplatform GUI is SQLiteStudio ( http://sqlitestudio.pl/ http://sqlitestudio.pl/ ).
- mjmsmith 10y ago
  Postico (https://eggerapps.at/postico/ https://eggerapps.at/postico/) is a really nice PostgreSQL client for OS X.
- justinclift 10y ago
  Cool timing. :) We (DB Browser for SQLite team) put this one-pager up yesterday about our upcoming "SQLite in the Cloud" project. :) https://dbhub.io https://dbhub.io
izacus 10y ago
While that may be true for Apple owners, it's very untrivial to install and properly configure (permissions, etc.) on Windows and Linux. SqLite usually "just works", can easily be reset if you do something wrong (just delete file!) and has better GUI browsers and tools.
- oliwarner 10y ago
  Linux? We're okay thanks. Apt and YUM (and the rest) make installing both MySQL and Postgres very easy.
- ufmace 10y ago
  I was rather surprised to find that installing PostgreSQL on Windows was loads faster and easier than installing MS SQL Server.

danso 10y ago

The one thing missing from SQLite is stronger type casting...however, SQLite does have a solid, cross-platform GUI in DB Browser [0]. It's not as nice as Sequel Pro and some of the commercial clients for MySQL. Postgres, unfortunately, doesn't have near the variety of reliable clients that MySQL and SQLite do. However, SQLite follows most of the standard syntax that Postgres does, so having students move right into CartoDB, which lets you run raw Postgres, has never been a problem.its just the self hosting that's a pain :). One more thing that I wish I could have from Postgres as a teacher: how it returns an error when you include non-aggregated columns in the SELECT clause. In MySQL and SQLite, selecting extra columns won't throw an error, and the results look close enough to correct to be fairly dangerous for novices. Better to just throw an error as Postgres does. [0] http://sqlitebrowser.org/ http://sqlitebrowser.org/

placebo 10y ago
Another good cross-platform GUI for SQLite that I've been using for years is TkSQLite (http://reddog.s35.xrea.com/wiki/TkSQLite.html http://reddog.s35.xrea.com/wiki/TkSQLite.html)
elchief 10y ago
Sqlite was a postgres fork, off of 8.something, IIRC
- yoo1I 10y ago
  No. This is incorrect.
- pmontra 10y ago
  It owes something to PostgreSQL but it's the syntax, not the source code. I quote from https://en.wikipedia.org/wiki/SQLite#History https://en.wikipedia.org/wiki/SQLite#History Hipp based the syntax and semantics on those of PostgreSQL 6.5. In August 2000, version 1.0 of SQLite was released, with storage based on gdbm (GNU Database Manager).
- elchief 10y ago
  According to these slides from Sqlite founder, Sqlite was a "spin-off" of Postgres: http://www.pgcon.org/2014/schedule/attachments/319_PGCon2014OpeningKeynote.pdf http://www.pgcon.org/2014/schedule/attachments/319_PGCon2014... According to this, "SQLite was originally written from PostgreSQL 6.5 documentation" https://www.pgcon.org/2014/schedule/events/736.en.html https://www.pgcon.org/2014/schedule/events/736.en.html So, "fork" wasn't the right word. Apologies.
googie 10y ago
Yet another free, open source and multiplatform GUI is SQLiteStudio ( http://sqlitestudio.pl/ http://sqlitestudio.pl/ ).
mjmsmith 10y ago
Postico (https://eggerapps.at/postico/ https://eggerapps.at/postico/) is a really nice PostgreSQL client for OS X.
justinclift 10y ago
Cool timing. :) We (DB Browser for SQLite team) put this one-pager up yesterday about our upcoming "SQLite in the Cloud" project. :) https://dbhub.io https://dbhub.io

izacus 10y ago

While that may be true for Apple owners, it's very untrivial to install and properly configure (permissions, etc.) on Windows and Linux. SqLite usually "just works", can easily be reset if you do something wrong (just delete file!) and has better GUI browsers and tools.

oliwarner 10y ago
Linux? We're okay thanks. Apt and YUM (and the rest) make installing both MySQL and Postgres very easy.
ufmace 10y ago
I was rather surprised to find that installing PostgreSQL on Windows was loads faster and easier than installing MS SQL Server.