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?
MySQL is a fully featured RDBMS. An example would be enterprise system or websites.<p>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.<p>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).<p>NoSQL is a broad term to refer to databases that are less restricted on the database's model associations than a relational one.
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)<p>SQL is a programming language to manage data and data definition in RDBMS. ("SELECT * FROM users WHERE lastname = 'Smith';")<p>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))
The main difference is whether the database runs in memory (mysql and sql), or it's file based (nosql and sqlite).<p>Wham downvoted. Is this information incorrect?