ncruces

8 ms·

31.
by ncruces 1mo ago
> Why on earth would I ever want to use SQLite if I have access to a sufficiently advanced code generator which can generate me a similarly high quality database system Because SQLite has 10k requirements that wouldn't even cross y
32.
by ncruces 1mo ago
On the one hand, yes. On the other, my country has just shut down 3G and 2G only stays because it's still used by emergency services. How long will 4G last? Longer than bluetooth and the Casio app? It'd be nice if something like t
33.
by ncruces 1mo ago
As I wrote: it does work great where it does work. I'd definitely have gone that route if it worked where I live. It's just that the marketing that it works "all around the world" falls pretty short, IMO. I kinda wish
34.
by ncruces 1mo ago
That “all around the world” leaves significant gaps: https://hagensieker.com/2019/11/17/multiband-6-what-is-it/ I had a weather station with an external antenna that could never sync, even during the nig
35.
by ncruces 1mo ago
Aren't you reading it the other way around? (I'm from another EU country where this rule existed) Other people have the right to rest on Sundays too, so you force as many activities to shutdown as possible to make it so. I don&#
36.
by ncruces 2mo ago
> More than 60% of my net worth is just from two stocks. I would hope you realize that your good fortune (aka luck) does not generalize to an entire population.
37.
by ncruces 2mo ago
Well adding the language features is a prerequisite to making these libraries possible.
38.
by ncruces 2mo ago
It's the length of an A4 sheet of paper (also, by extension, the size of many school books, backpacks and … rulers).
39.
by ncruces 2mo ago
The greatest thing about generics is … that they're not used much if at all. Which is a great way to make sure they're not overused, which in my experience is better than underuse.
40.
by ncruces 2mo ago
Maybe your heroes did. And no one gives a shit about the (18 million) Dutch, but we picked Bertha von Suttner.
41.
by ncruces 2mo ago
Maria Skłodowska-Curie was very helpful, at trying to solve #2 and #5 countries (by population) in one stroke. Good that the big 5 EU countries were simple enough to cover. But why are a Greek-American, and an - unknown to the majority of E
42.
by ncruces 2mo ago
No.
43.
by ncruces 2mo ago
Go doesn't rely on much C/C++, not recently at least. Particularly on Linux.
44.
by ncruces 2mo ago
Exactly. Faces are a terrible idea for a common currency shared by 21 countries. You have to pick one writer, good that the English left for good so Shakespeare's out, but how do the French feel about Cervantes vs. Victor Hugo? The Pol
45.
by ncruces 2mo ago
If you take that approach, Ukraine is still a special operation.
46.
by ncruces 2mo ago
I wrote this bump malloc that I use for very short lived Wasm modules: https://github.com/ncruces/wasm2go/blob/main/libc-gen/c/mall...
47.
by ncruces 2mo ago
The article should note this: it's important that you don't go adding other/all little endian platforms to that go:build line. The article is correct, but this code is only valid for platforms that allow unaligned access. You
48.
by ncruces 2mo ago
The forum post I linked to has a 3 line example: CREATE TABLE t1(a DATE, b JSON); PRAGMA strict=ON; INSERT INTO t1 VALUES(a,b) VALUES(?1,?2); You (or the author) can replace the non-existent `PRAGMA strict` with whatever editions
49.
by ncruces 2mo ago
That's certainly not the case for making STRICT tables the default. But figuring that out requires understanding how they are implemented, or reading the forum, which the author admittedly didn't do. The rest are assumptions about
50.
by ncruces 2mo ago
OK, but this: > This should be a nice middle ground which avoids breaking backwards compatibility, but lets the database engine move forwards and not be bogged down by its own history. Does nothing to address my criticism. Handwaving &
51.
by ncruces 2mo ago
I get a quota of GitHub Copilot for free. From all the models available to me I'm most happy with Kimi K2.7 (given the cost/performance).
52.
by ncruces 2mo ago
> The section "The solution: editions?" in the article addresses directly the point of existing data. I'm sorry, where? SQLite schema is stored as text. If you change the default interpretation of CREATE TABLE with a PRAGM
53.
by ncruces 2mo ago
This changes one default that "everyone agrees about" and which you can change with a compile time option: SQLITE_DEFAULT_FOREIGN_KEYS Then it argues for STRICT tables, recognizing that there are drawbacks without introducing a ne
54.
by ncruces 2mo ago
> Is a dumb sea mine that blows up everything somehow better than a smart sea mine that knows to not blow up sometimes? Yes. If smart mines lead to belligerents laying more of them because they're "safer."
55.
by ncruces 2mo ago
Stuff that cares about security fixes this, though: https://go.dev/blog/path-security The functions Command and LookPath look for a program in the directories listed in the current path, following the conventions of t
56.
by ncruces 2mo ago
Precisely, this is my experience as well. If you use strict tables with my Go SQLite driver, you'll get worse support for bool/date/time columns than otherwise. It's still unfortunate though that typing a column DECIMA
57.
by ncruces 2mo ago
A comment is not something I can get programmatically through `sqlite3_column_decltype` or `sqlite3_table_column_metadata`. I can use either API to trigger bool and time handling in my Go driver. https://github.com/ncruces&#
58.
by ncruces 2mo ago
I always loved the "syntax" of the "beautiful report language" and how the [] meshed with Scheme's () and HTML/XML <> (and maybe JSON {}). https://brl.sourceforge.net/
59.
by ncruces 2mo ago
The downside is that you loose the place to store the metadata that a column is supposed to store a date. Which is why I prefer not to use them.
60.
by ncruces 2mo ago
Only if you're not compiling yourself, otherwise, there's SQLITE_DEFAULT_FOREIGN_KEYS=1

More ›