News for hackers. Stuff that matters.

Differences between NoSql, MySql, Sqlite and Sql?

What's the differences between noSql, mySql, sqlite and sql? I have only used Sqlite3 when I was developing a website with Django and a little bit of MySql when I worked on wordpress during summer, what are the other database languages like?
( 4 comments | 5 points | on HN )
Re:Differences between NoSql, MySql, Sqlite and Sql? by talles on Monday December 02, 2013 @07:54AM (#6833296)
MySQL is a fully featured RDBMS. An example would be enterprise system or websites.

SQLite is also a RDBMS but a lightweight one, it doesn't require it's own process, clustering or user management unlike MySQL or others RDBMS. SQLite consist of a single file and a library to make your application interact with it. The typical example is storing bookmarks on a web browser, or minor database in mobile apps.

SQL is the language standard to interact with RDBMS. While it's the same language, it has minor non-standard variations flavors (like Microsoft's Transact-SQL).

NoSQL is a broad term to refer to databases that are less restricted on the database's model associations than a relational one.

Re:Differences between NoSql, MySql, Sqlite and Sql? by tlubinski on Monday December 02, 2013 @03:11AM (#6832448)
MySql and Sqlite are relational database management systems (RDBMS), which hold databases that are based on relations. (Other RDBMS are e.g. Postgresql or MS SQL Server)

SQL is a programming language to manage data and data definition in RDBMS. ("SELECT * FROM users WHERE lastname = 'Smith';")

NoSQL is a term which describes database systems that don't understand SQL and usually work as key-value store. (Examples: Riak, Redis, MongoDB (document-based))

Re:Differences between NoSql, MySql, Sqlite and Sql? by t0 on Monday December 02, 2013 @12:44AM (#6831922)
The main difference is whether the database runs in memory (mysql and sql), or it's file based (nosql and sqlite).

Wham downvoted. Is this information incorrect?

Re:Differences between NoSql, MySql, Sqlite and Sql? by dangrossman on Monday December 02, 2013 @03:41AM (#6832533)
Yes, this information is incorrect. MySQL does not "run in memory" moreso than other RDBMS's; it has various in-memory caches but persists your data to disk. SQL is not a database, but the language you use to talk to one. NoSQL is not a specific file-backed database but a category of software, some of which persist data to disk and some of which don't.