Posts by Conornash@mastodon.social
 (DIR) Post #AKrTTntjdZ3mYnCRqC by Conornash@mastodon.social
       2022-06-23T02:37:51Z
       
       0 likes, 0 repeats
       
       Ahem... (hot take voice) #PostgreSQL is the #Emacs of databases.
       
 (DIR) Post #AKrTTpWPbFalb2IqlU by Conornash@mastodon.social
       2022-06-23T02:40:22Z
       
       0 likes, 0 repeats
       
       I keep finding new things that PostgreSQL does, that it turns out it has done for years. I was looking to strip HTML from a text field, and found out it has an XML parser + corresponding datatype! Built in! https://www.postgresql.org/docs/9.1/datatype-xml.html
       
 (DIR) Post #AKrTTr6biA8gVaFGoy by Conornash@mastodon.social
       2022-06-23T02:42:40Z
       
       0 likes, 0 repeats
       
       Did you want to run a full text search? It has separate datatypes for text & query too! https://www.postgresql.org/docs/current/datatype-textsearch.html
       
 (DIR) Post #AKrTTsoFNOdnnDfdTs by Conornash@mastodon.social
       2022-06-23T02:48:22Z
       
       0 likes, 0 repeats
       
       It has the "@>" operator, which does so much stuff I can't even begin. Ranges! As a first class operation! Agnostic to the underlying types! 🤯🤯🤯
       
 (DIR) Post #AKrTTuFa1G6CGHSyiu by Conornash@mastodon.social
       2022-06-23T02:57:25Z
       
       0 likes, 0 repeats
       
       And I haven't even started on the fact that there are four - FOUR - different languages that you can write your SQL functions in. 🏠BUILT 🏠 IN! 🏠
       
 (DIR) Post #AQkEBvzgcqg4KQ1Ku8 by Conornash@mastodon.social
       2022-12-18T22:11:29Z
       
       0 likes, 0 repeats
       
       @mastodonusercount Feels like another wave is kicking off again here...
       
 (DIR) Post #AWucgiaxo0Puo31kSO by Conornash@mastodon.social
       2023-06-21T09:45:33Z
       
       0 likes, 0 repeats
       
       @simon Installing right now! Only learned of `llm` yesterday so this is perfect timing 😄