Viewing profile — ncruces

> 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 SQL…

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 a…

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" …

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 sy…

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 activitie…

> 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.

Well adding the language features is a prerequisite to making these libraries possible.

It's the length of an A4 sheet of paper (also, by extension, the size of many school books, backpacks and … rulers).

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.…

Maybe your heroes did. And no one gives a shit about the (18 million) Dutch, but we picked Bertha von Suttner.

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…

No.

Go doesn't rely on much C/C++, not recently at least. Particularly on Linux.

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 t…

If you take that approach, Ukraine is still a special operation.

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...

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 f…

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 no…

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 ad…

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 hist…

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).

> 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 i…

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…