Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
ncruces
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
52 ms
·
901.
▲
by
ncruces
3y ago
My primary school kid loved it. https://news.ycombinator.com/item?id=39323511
902.
▲
by
ncruces
3y ago
Only if people loose the ability to appreciate simple things. 2048 is a lot of fun. So is wordle. Or the xor game that made HN a week ago.
903.
▲
by
ncruces
3y ago
This bit becomes particularly ironic: But the point is that without the available knowledge online and access to components needed to repair it, it would have remained a dead relic of decades past.
904.
▲
by
ncruces
3y ago
And for an image previewer I'd care. If I'm opening a codebase with thousands of files, I don't mind to wait a couple of seconds, as long as it's responsive afterwards.
905.
▲
by
ncruces
3y ago
Startup would have to be terrible for me to bother. VS Code starts in under a couple of seconds, and I have it open all day long; once open, other windows open even faster than that. If it took any longer than a couple of seconds, I'd
906.
▲
by
ncruces
3y ago
Because in the US they will not be forced to (and likely won't) allow Firefox, Chrome, Brave, etc, with their own rendering engines, on the App Store, and if they do, they will definitely not allow them to become the PWA storefronts th
907.
▲
by
ncruces
3y ago
struggling figuring out how to make my cgo sqlite cross-compile to Windows Plenty of people trying to fix that. There's at least: https://modernc.org/sqlite Then there's https://github.com/zombie
908.
▲
by
ncruces
3y ago
After years of Qualcomm not updating its wearable chips and keeping them on 22nm, Samsung had exclusive first dibs access to its own 5nm chip. A new version of Android was built that required newer chips, and that's what it took for Qu
909.
▲
by
ncruces
3y ago
SQLite extensions are mostly meant to be dynamically linked, so the LGPL is entirely appropriate, IMO. If anything I'd ask for an exception to allow statically linking unmodified builds (e.g. my use case, WASM, requires static linking
910.
▲
by
ncruces
3y ago
Just one note on using the incremental BLOB I/O API that you might want to consider (if you're not aware of it, I wasn't, found it unintuitive) is that blobs larger than page size are stored in linked lists of pages, and ther
911.
▲
by
ncruces
3y ago
Judging from [1] I think your intuition about performance and particularly storage improvements is correct. 1: https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html
912.
▲
by
ncruces
3y ago
I may be missing something, but I'm not sure you need to detect COUNT(*) specifically. For a query that's just SELECT COUNT(*) FROM… SQLite will just iteratively call xNext/xEof to count rows. As long as you don't actual
913.
▲
by
ncruces
3y ago
The toggle is supposed to convey immediateness, like a light switch turning on bluetooth is immediate. A checkbox is like filling a form, it requires submission for the action to take place.
914.
▲
by
ncruces
3y ago
Like Sweden? https://en.wikipedia.org/wiki/Sweden_Solar_System
915.
▲
by
ncruces
3y ago
It's a bit hard to take your objection very seriously when the following spits out the same SQLite as in PostgreSQL: CREATE TABLE tbl (x integer, y real); INSERT INTO tbl VALUES ('001', ' 2.5 '); SELEC
916.
▲
by
ncruces
3y ago
In a society that considers most rich people "bad actors" or "evildoers" ( i.e. they'd never be that rich if this was a fair game), that's pretty erm… rich of you to say.
917.
▲
by
ncruces
3y ago
I don't find a DB that losslessly stores what I told it to store regardless of types worrying at all. So in fact AFAIC the misfeature of SQLite is not that it's typeless, IMO, rather it's that it has this notion of NUMERIC af
918.
▲
by
ncruces
3y ago
The rational was to design a format that can serve as a (flattened) parse tree for the JSON. JSON handling functions in SQLite took in textual JSON and mostly spat out JSON text. So their structure was: (1) parse JSON, (2) massage in memory
919.
▲
by
ncruces
3y ago
This is wrong. Integers (in SQLite columns) are stored as varints and floats as IEEE 754 doubles. Numbers in JSONB are stored as text.
920.
▲
by
ncruces
3y ago
That's more and more? Only someone completely removed from European politics would write that.
921.
▲
by
ncruces
3y ago
A threaded interpreter still has one branch per bytecode instruction; a copy-and-patch JIT removes this overhead.
922.
▲
by
ncruces
3y ago
The European Union was a major landmark, but it looks like more and more countries are breaking away. What's this supposed to mean?
923.
▲
by
ncruces
3y ago
If fusing a certain pair would significantly improve performance of most code, you'd just add that fused instruction to your bytecode and let the C compiler optimize the combined code in the interpreter. I have to assume CPython as alr
924.
▲
by
ncruces
3y ago
If it was that easy, you'd do that in the interpreter and proportionally reduce interpretation overhead.
925.
▲
by
ncruces
3y ago
You could totally avoid that accident by not building the road in the first place, which typically is the first level of paralysis we need to overcome.
926.
▲
by
ncruces
3y ago
Then just use Yaegi, which I linked to above. It has the limitations mentioned, which are necessary to make duck-typed interface calls reasonably efficient, if you assume no code generation at runtime, ever. There's really no other way
927.
▲
by
ncruces
3y ago
How does that prevent an unset Value from being used?
928.
▲
by
ncruces
3y ago
Just you guess: Python, C++ and Java… and Go. Or JavaScript, Dart, Objective-C, Swift, Rust; even C#. But then it depends on the problem domain. Google it huge, so it depends. And that's even if you pick Python, C++, Java or Go. So y
929.
▲
by
ncruces
3y ago
Yes. There are long standing feature requests for (e.g.) the reflect package that simply don't get done because they'd break this assumption and/or force further indirection in hot paths to support "no code generation at
930.
▲
by
ncruces
3y ago
Sorry, but no. Interfaces and how they ended up limiting generics (parametric polymorphism) are a tradeoff. Structural interfaces (duck-typed in an otherwise static-typed, with composition-over-inheritance, language) are innovative, interes
More ›