SQLITE VS MYSQL VS H2 SOFTWARE

Yes (*) When Postgres compatibility is enabled (Yes) (*) No WHERE clause is allowed e.g. Temporal queries (*) Temporal queries allow querying the database (or a single table) to return the data as it was in the past GROUPING SETS (*) Create multiple independent groups with a single GROUP BY query No (*) The crosstab function can be used for this. in a common table expression directly.įiltered aggregates (*) Only include rows in an aggregate based on a condition: avg(salary) filter (where dept_id = 1) Yes (*) Can only be used in a FROM, not e.g. Sometimes also called 'table value constructor'. Row constructor (*) Use of the VALUES row-constructor wherever a table reference can be used. A CTE name can not be re-used in the same transaction Can not be used in views Can not be used with sub-queries Can not be used with INSERT statements. (Yes) (*) All columns are treated as varchar. Yes (*) DISTINCT is not supported inside a window functionĬTE in a sub-query (*) Use a common table expression in a sub-query, not only as a top level query

To get a more in-depth comparison about some of the SQL features compared here, please visit Modern SQL Oracle Postgres SQL Server IBM DB2 MySQL MariaDB Firebird H2 HSQLDB SQLite Feature Features for database administration or deployment are also not the focus of this comparison.

SQLITE VS MYSQL VS H2 SOFTWARE

This comparison focuses on SQL features that can be used in SQL statements or self-contained SQL scripts that don't requireĪdditional software (e.g. (The tooltips don't work on Internet Explorer 10 or older versions. Items with (*) have a comment (or explanation) that is shown as a tooltip when hovering the mouse over them

Sqlite vs mysql vs h2