I’m pretty excited about PRQL. If anything has a shot at replacing SQL, it’s something like this (taken from their FAQ):
PRQL is open. It’s not designed for a specific database. PRQL will always be fully open-source. There will never be a commercial product.
There’s a long road ahead of it to get serious about replacing SQL. Many places won’t touch it until there’s an ANSI standard and all that. But something built with those goals in mind actually might just do it.
I don’t think you really have a choice TBH. Trying to do something like that sounds like a world of pain, and a bunch of unidiomatic code. If you can’t actually support 4 to 10 languages, maybe you should cut back on which ones you support?
One interesting thing you could try if you really don’t want to cut back is to try having using an LLM to take your officially supported code and transliterate it to other languages. I haven’t tried it at this scale yet, but LLMs are generally pretty good at tasks like that. I suspect that would work better than whatever templating approach you’ve used before.
If neither of those approaches works, everything speaks C FFI, and Rust is a modern language that would work well for presenting a C FFI that the other languages can use. You’re probably not hot on the idea of rewriting your Go tests into another language, but I think that’s your only real option then.
To do it 100% probably isn’t possible, something something halting problem. However, you’d catch a lot of basic mistakes with proper typing. In your example, the first function should be typed like this: fn third_planet_from_sun() -> Planet, where Planet is an enum. De/serializing it still has the same problem of interpreting an arbitrary string, but at least for deserializing it, you can be loose in what you allow and just lowercase it before matching it to the enum.
That’s true, but also trying to create first has a race condition too. The above code will panic at the unwrap if the record is deleted after the failed insert, and before the select
This is likely what OP will have to do. It actually looks like ANSI SQL now has merge, but you can scroll down a bit and see how each DB handles it slightly differently if you don’t use merge.
Did anyone ever figure out exactly what happened with the mod team stepping down? Does this leadership change help address that?
It was made to do so, but failed from the start exactly because humans got involved. semver’s ideals can only happen when tooling generates the version number, not humans.
semver is a nice way to communicate your intent to other humans, but it’s never been a great way of programmatically communicating those changes. If you want it to communicate something meaningful programmatically, you’d have to have the version generated automatically, and not rely on a human to do so.
What advantages does that have over this?
Here’s a couple of quick games that I like:
Yeah. OP, you imply that you’re trying to get insight into a more general case, but TBH for the scenario you’ve presented: you’re overthinking it. Just use a fixed size array.
If you want fancy things like grid rotation handling, just store it in a Vec and provide a rotated view of it with an iterator.
Concept might work well. The cards are going to have a concept that you try to get other people guess by pointing at a board with various symbols on it. The word for the concept you’re trying to get people to guess should be easily translated with a phone, or just skipped and draw a new card.
Rhino Hero is great, especially if there’s kids or drunk adults in the group. Kind of like Jenga, try to build up a card tower without knocking it over.
Similarly, Pinnacle’s pretty good. Competitive block stacking with weird shapes
Makes me wonder if in a few years you’ll be able to throw your entire source into an LLM and say “rewrite in Rust plz”. I’ve encountered the same hallucinations for codegen that people are familiar with, but I’ve noticed that it’s a lot better when responding to grounded questions like that. I’ve only tried language conversion with short scripts, but with the race for larger context window sizes, I could see whole-repo conversions.
Put some lava lamps in frame too and use it as a source of RNG:
https://blog.cloudflare.com/randomness-101-lavarand-in-production/
The crate in question, if anyone else is curious: https://lib.rs/crates/bitcoin
I couldn’t find it by searching bitcoin, which makes me wonder if it’s also deranked somehow
I’m too lazy to convert that by hand, but here’s what chatgpt converted that to for SQL, for the sake of discussion:
SELECT a.id, a.artist_name -- or whatever the name column is in the 'artists' table FROM artists a JOIN albums al ON a.id = al.artist_id JOIN nominations n ON al.id = n.album_id -- assuming nominations are for albums WHERE al.release_date BETWEEN '1990-01-01' AND '1999-12-31' AND n.award = 'MTV' -- assuming there's a column that specifies the award name AND n.won = FALSE GROUP BY a.id, a.artist_name -- or whatever the name column is in the 'artists' table ORDER BY COUNT(DISTINCT n.id) DESC, a.artist_name -- ordering by the number of nominations, then by artist name LIMIT 10;I like Django’s ORM just fine, but that SQL isn’t too bad (it’s also slightly different than your version though, but works fine as an example). I also like PyPika sometimes for building queries when I’m not using Django or SQLAlchemy, and here’s that version:
q = ( Query .from_(artists) .join(albums).on(artists.id == albums.artist_id) .join(nominations).on(albums.id == nominations.album_id) .select(artists.id, artists.artist_name) # assuming the column is named artist_name .where(albums.release_date.between('1990-01-01', '1999-12-31')) .where(nominations.award == 'MTV') .where(nominations.won == False) .groupby(artists.id, artists.artist_name) .orderby(fn.Count(nominations.id).desc(), artists.artist_name) .limit(10) )I think PyPika answers your concerns about
It’s just regular Python code, same as the Django ORM.