What database engine is SQLPad based on?
(Update 01/26, 2022, we now also support MySQL and Python, more info.)
Great question, SQLPad's online playground, and the coding challenge's online judge is currently based on the latest Postgres.
Its query syntax is similar to other databases such as MySQL or Microsoft SQL Server, one of the major differences is on Postgres's DateTime related functions.
More details can be found here: https://www.postgresql.org/docs/current/functions-datetime.html
For example, there is no datediff function in Postgres, but you can subtract one DateTime column from another directly using the minus '-' operator, which is actually quite convenient and easier to type once you get the hang of it.
If you would like to see other database engines implemented on SQLPad, please let us know.
Have more questions? Please feel free to contact us, we read and respond to every email you send us, just give us some time. 😃