deemarklit

4 ms·

1. 1.▲
   by deemarklit 3y ago

   Links: SQLGlot - https://news.ycombinator.com/item?id=31981568 , https://github.com/tobymao/sqlglot Presto - https://github.com/prestodb/presto
2. 2.▲
   Ask HN: recommending a SQL transpiler

   3 points by deemarklit 3y ago|1 comments
3. 3.▲
   by deemarklit 3y ago

   I don't mind the mysql docs at all. What's an example where you've found the docs irritating with the other two? (mariadb I've had troubles finding things in the docs)
4. 4.▲
   by deemarklit 3y ago

   I see. When you say 'agnostic SQL', which data types or features do you usually have to give up? Also, do mixed-type comparisons ever get in the way, as these are usually handled differently in Postgres vs SQLite vs MariaDB -- for
5. 5.▲
   by deemarklit 3y ago

   So cool, I didn't realize how deep the JSON and XML functionality out of the box were. So much better than the support that Mysql or most others have. Thanks for sharing! Also, when do you find yourself using Arrays in a database? (ins
6. 6.▲
   by deemarklit 3y ago

   What would be an example of where you prefer postgres over something else? What's your favorite part of the syntax?
7. 7.▲
   What is your favorite SQL dialect and why?

   4 points by deemarklit 3y ago|10 comments