dgllghr

7 ms·

31.
by dgllghr 1y ago
It never hurts to remember that many of the original European settlers to what is now the US were religious radicals who were forced out of Europe because of their religious beliefs. Their influence lives on to this day
32.
by dgllghr 1y ago
Oh I missed that on my first read through of the README. Very nice!
33.
by dgllghr 1y ago
I wish the macro approach to SQLite in Swift was about generating types from a raw query rather than generating table types. I don’t want an ORM. I want to be able to write raw SQL and have the compiler check that SQL for correctness and ge
34.
by dgllghr 1y ago
Now I understand. Thanks!
35.
by dgllghr 1y ago
Thank you for GRDB! I am using it in a project now and it’s been great. About the benchmarks in this repo though, how can SQLiteData be faster if it uses GRDB under the hood? Are they doing something inefficient or are they bypassing GRDB i
36.
by dgllghr 1y ago
I agree. I love my AirGradient monitor. I’ve had it for years and it still works wonderfully.
37.
by dgllghr 1y ago
And Kirkpatrick has been pushing Americans not to believe in UFOs. When he took over AARO it was a sudden U-turn. Why would the Pentagon make him the head of AARO if he was going to go against their UFO narrative?
38.
by dgllghr 1y ago
If you are seriously interested in this, then I would appreciate your answers to these questions! What is the specificity of your shopping list? Cheerios 12 oz, Cheerios, cereal, etc.? If cereal, is it a standin for the all the cereals you
39.
by dgllghr 1y ago
I unfortunately think this is a case of manufactured consent: > You don’t say something because it’s true; you say it because you believe it—and you believe it because it’s what gets rewarded.
40.
by dgllghr 1y ago
Databases like that do exist. There is ArangoDB for example. I have no idea if it’s any good
41.
by dgllghr 1y ago
I believe AGE has unfortunately been defunded: https://github.com/apache/age/discussions/2150 It’s a shame because it seemed like being able to query data across multiple paradigms would be really useful
42.
by dgllghr 2y ago
Sure! Here is a use case that I have now encountered multiple times. We want to do data ingestion of some kind, but one of the steps involves human intervention (editing, confirmation, annotation, etc.). For these human intervention steps,
43.
by dgllghr 2y ago
Looks very nice with a well thought out landing page and explainer video. I wish there was an offering like this that also included a low-code interface builder like Retool/Budibase/etc. so that it was easy to put a human in the l
44.
by dgllghr 2y ago
My goal isn’t to get anyone’s hopes up about a drug fixing all issues. It’s more to encourage to cover the basics in case it helps. Because it did for me and it’s something I could have done sooner
45.
by dgllghr 2y ago
This is a psychological issue, but everything psychological is also physical. It’s all one interconnected system. So please see a doctor and have your bloodwork done. Doing that was the first step to escaping my burnout. I wish I had done i
46.
by dgllghr 2y ago
We had this exact problem outside my son's room. Birds would wake him up at 5 am. I put one of those fake plastic owls with a bobble head outside his window. Problem solved.
47.
by dgllghr 3y ago
It doesn't have to be like this though. Actors and others who work on sets with David Lynch always talk about how wonderful he is to work with and how well he treats everyone. And he is also a man with singularity of vision who does th
48.
by dgllghr 3y ago
So if I understand correctly, methanol is a low emission fuel source because the CO2 is taken from the air or from plants that have captured it from the air? But if there isn’t enough supply of methanol now, won’t the gap just be filled by
49.
by dgllghr 3y ago
Yea for sure. Just take your time Boeing? No pressing issues to address or anything...
50.
by dgllghr 3y ago
That looks great, thanks for sharing! Given that the zig build system uses zig and zig just got an http client in the standard library, I think it would be feasible to port into stanchion's build. Out of curiosity, do you run unit test
51.
by dgllghr 3y ago
SQLite has a built in mechanism for loading extensions at runtime. The extensions themselves are just dynamic libraries. The main entry point for the extension is an init function that SQLite calls when the library is loaded. Within that in
52.
by dgllghr 3y ago
No diminishment taken :) I hope you find something that works for your needs
53.
by dgllghr 3y ago
That is a great trick for COUNT(*), thank you! That's disappointing about xFindFunction. Once I start digging into it more, I will let you know if I find any other clever tricks that you might be able to use in your extensions as well.
54.
by dgllghr 3y ago
Stanchion already has support for a few kinds of compression that leverage patterns in a sequence of data of the same type (DuckDB calls this "lightweight compression"). Stanchion supports: bit packing for booleans and integers an
55.
by dgllghr 3y ago
Thanks for your thoughtful questions! * SQLite has rock solid support for transactionally persisting data to disk, which is a difficult and complex thing that stanchion gets almost for free. But the downside is fitting the architecture of s
56.
by dgllghr 3y ago
Including the sqlite source is for the convenience of running unit tests without needing to rely on sqlite as an external dependency :)
57.
by dgllghr 3y ago
Yes it does. I have found it easier to start simple than try to integrate the complexity of Parquet whole hog. The Parquet format is also designed with the idea of having multiple columns in the same "file". I'm sure there ar
58.
by dgllghr 3y ago
DuckDB is great! But row-oriented storage is also great for many use cases. My goal is to provide a way for people to have access to the benefits of column-oriented storage without leaving behind the benefits of OLTP. Many people are alread
59.
by dgllghr 3y ago
Thanks for the kind words, Alex! You have probably written more great sqlite extensions than anyone, so your feedback is very meaningful. You are right that there are limitations. The sqlite virtual table API is very clearly designed with r
60.
Show HN: Stanchion – Column-oriented tables in SQLite(github.com)
273 points by dgllghr 3y ago|60 comments

More ›