SQL is great, but what is even better is a SOTA client. https://github.com/elixir-dbvisor/sql the BEAM can give you superpowers that no other platform can, handle massive concurrency with the performance that rivals bare metal and c https://erlangforums.com/t/elixir-dbvisor-sql-needs-a-sota-p...
Readit Newsschultzer commented on The Rise of SQL:the second programming language everyone needs to know spectrum.ieee.org/the-ris... · Posted by u/b-man
schultzer commented on Why I Chose Elixir Phoenix over Rails, Laravel, and Next.js akarshc.com/post/phoenix-... · Posted by u/akarshc
OTOH JS is too big for my taste. Everything has 10 implementations with no consensus about doing things. So everyone chooses their own horrible menu. Like an American super market. Or you go full chain restaurant with whatever Vercel pushes currently
Couldn’t agree more, I was taking a diplomatic approach as I was linking to my own work!
schultzer commented on Why I Chose Elixir Phoenix over Rails, Laravel, and Next.js akarshc.com/post/phoenix-... · Posted by u/akarshc
A lot of people tend to flag Elixir for its size and rightfully so, but the community is trying to punch above it’s weight with SOTA libraries. As an old developer once told me: less is more. https://github.com/elixir-dbvisor/sql
schultzer commented on Denmark tests unmanned robotic sailboat fleet apnews.com/article/denmar... · Posted by u/domofutu
Great to see this, Denmark would do well having an autonomous regiment in the Navy, Airforce and Army.
schultzer commented on LLMs and Elixir: Windfall or deathblow? zachdaniel.dev/p/llms-and... · Posted by u/uxcolumbo
Having used Elixir for multiple years on something other than a server application, I disagree with calling Elixir a general purpose programming language. It’s really good for writing servers, I’ll give it that, but for stuff that isn’t an always-on network application, I felt the OTP way of doing things was designed for something I wasn’t building. Elixir makes it very easy to build servers, but the language and community are very biased towards client/server use cases. It certainly can be used for things other than server, much like I could build a web app using QBasic or Excel. The focus of the language, its history and the community around Elixir has always been server apps. To me, that’s the biggest indicator that it’s a specialized language rather than a general purpose language.
I disagree, it’s wonderful for writing compilers in as well https://github.com/elixir-dbvisor/sql I would go so far as to say superior to a lot of other languages that do not have advanced pattern matching.
schultzer commented on Show HN: SQL-tString a t-string SQL builder in Python github.com/pgjones/sql-ts... · Posted by u/pgjones
Languages should strive to type safely inline SQL and other structured data.
With Java the manifold project achieves this via compiler plugin. The manifold-sql[1] module provides inline, type safe, native SQL.
1.https://github.com/manifold-systems/manifold/blob/master/man...
If your language has macros you can get by as well https://github.com/elixir-dbvisor/sql
schultzer commented on Show HN: SQL-tString a t-string SQL builder in Python github.com/pgjones/sql-ts... · Posted by u/pgjones
Thanks, do you have a reference for SQL grammar - I've had no success finding an official source.
You can google SQL grammar. But here is the 2025: https://standards.iso.org/iso-iec/9075/-2/ed-6/en/
schultzer commented on Show HN: SQL-tString a t-string SQL builder in Python github.com/pgjones/sql-ts... · Posted by u/pgjones
Just took a quick look, and it seams like the parser is hand written which is great, but you probably want to build a lexer and parser based on the BNF grammar take a look at how I do it here https://github.com/elixir-dbvisor/sql/tree/main/lib and do conformance testing with https://github.com/elliotchance/sqltest
schultzer commented on Show HN: SQL-tString a t-string SQL builder in Python github.com/pgjones/sql-ts... · Posted by u/pgjones
Not really sure what a t string is or if it’s a macro, but feel similar to https://github.com/elixir-dbvisor/sql but less elegant and ergonomic.
And when you do have to jump off, you'll be screwed. Because the jump off is usually from in-memory Mnesia with guaranteed sub-millisecond responses to a proper database with at least a magnitude higher latency. And you realize that your app is completely dependent on sub-millisecond responses :)
Low latency is addictive. And by the time when you think you might need to change you’re probably become such a skilled engineer that you realize that everybody that shit on mnesia does not know what they talk about. :)