Quoted post unavailable.
No post body was provided.
D1: Our SQL database
181–190 of 241 posts
Re: D1: Our SQL database
#182Quoted post unavailable.
I prefer to make the world better through actions.
Not pointlessly redefining words that have no ill intent in the first place and harassing people that don't use the words you decided were proper.
Re: D1: Our SQL database
#183Earlier quoted context omitted.
Quoted post unavailable.
Because it is being used for manipulation, falsely. "Oh, oh, this hurts me! I cannot bear it!" Recollect Emory University, in 2015, when someone wrote "TRUMP 2016" in chalk on the sidewalk. "Traumatized" protestors shouted "You are not listening! Come speak to us, we are in pain!" It's manipulation, pretending to be hurt. These people weren't locked in some kind of perpetual seizure for the four years of the Trump pr…
Can you explain what incentive someone has to "manipulate" us into no longer using the term slave, if not genuine discomfort?
Re: D1: Our SQL database
#184Earlier quoted context omitted.
* the big one for me: very limited migration support, requiring quite a lot of ceremony for common tasks (eg rewriting a whole table and swapping it out) I don't know where this idea of having to swap a whole table in SQLite came from, but it simply isn't true. Over the last 13 years I have upgraded production HashBackup databases at customer sites a total of 35 times without rewriting and swapping out tables by usin…
It would really help if SQLite3 had a `MERGE`, or, failing that, `FULL OUTER JOIN`. In fact, I want it to have `FULL OUTER JOIN` even if it gains a `MERGE`. `FULL OUTER JOIN` is the secret to diff'ing table sources. `MERGE` is just a diff operation + insert/update/delete statements to make the target table more like the source one (or even completely like the source one). `FULL OUTER JOIN` is essential to implementin…
RIGHT and FULL JOIN are on the trunk branch of SQLite and will (very likely) appear in the next release. Please grab a copy of the latest pre-release snapshot of SQLite (https://sqlite.org/download.html) and try out the new RIGHT/FULL JOIN support. Report any problems on the forum, or directly to me at drh at sqlite dot org.
Re: D1: Our SQL database
#185wow SQLite getting a lot of love these days https://tailscale.com/blog/database-for-2022 https://fly.io/blog/all-in-on-sqlite-litestream https://blog.cloudflare.com/introducing-d1
SQLite is great but it's way overhyped and abused on HN. People are very eager to turn SQLite into a durable, distributed database and it's really not meant for that, and by going down that road instead of using something like MySQL or Postgres you're missing out on lots of important functionality and tooling. I only say this because I have made this mistake at my previous startup. We built these really cool distribu…
I'm not sure why you concluded that SQLite is the problem when you built a "really cool distributed database" with Kafka. Distributed databases are complicated, Kafka's complicated.
If you're saying that a replicated Postgres setup would be simpler than what you're built, I agree; but SQLite+Litestream probably would be too.
Re: D1: Our SQL database
#186Re: D1: Our SQL database
#187Earlier quoted context omitted.
The person you're replying to is very kind and considerate. They're not assuming people using the problematic terminology do so with the intention to harm. They are, however, mindful of its negative effects, hence the gentle reminder.
The person I am replying to is very kind indeed. The rest of society obsessed with this political correctness madness are extremely hostile, engaging in shaming and generally have sadistic vibes of oppressing people with their moral superiority – which has zero basis except they discovered a new offending word to pile up on others. This needs to stop IMO.
The behavior you're describing exists, but I don't think what you are describing is a minority behavior, generally exhibited by people who often suffer directly from the use of said terminology. I don't condone violence, but anger is understandable in that case.
Also, if an idea has some idiotic proponents doesn't mean it's inherently false.
Minorities are in the process of gaining cultural power and influence, to the detriment of the majority. This is unpleasant when you are on the receiving side, but IMO necessary right now.
Re: D1: Our SQL database
#188Not clear from reading the post if the SQLite C library is embedded and linked in the Worker runtime (which would mean no network roundtrip) or if each query or batch of queries is converted to a network request to a server embedding the SQLite C library.
That's important to understand because that's one of the key advantages of SQLite compared to the usual client-server architecture of databases like PostgreSQL or MySQL: https://www.sqlite.org/np1queryprob.html
Re: D1: Our SQL database
#189I was expecting this to be using https://en.wikipedia.org/wiki/D_(data_language_specification... given the name.
Re: D1: Our SQL database
#190Earlier quoted context omitted.
Because it is being used for manipulation, falsely. "Oh, oh, this hurts me! I cannot bear it!" Recollect Emory University, in 2015, when someone wrote "TRUMP 2016" in chalk on the sidewalk. "Traumatized" protestors shouted "You are not listening! Come speak to us, we are in pain!" It's manipulation, pretending to be hurt. These people weren't locked in some kind of perpetual seizure for the four years of the Trump pr…
Can you explain what incentive someone has to "manipulate" us into no longer using the term slave, if not genuine discomfort?
Well, why did the histrionics at the campus occur? Do you feel their discomfort was genuine? Bonus question: if it was genuine, what would you expect the outcome to be for them during the Trump presidency?