Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
srcreigh
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
67 ms
·
931.
▲
by
srcreigh
5y ago
For what it's worth, spiritual teachers believe psychedelics open people up to spiritual realities. That's pretty much the life story Ram Das (ex psych professor). Orthodox Christian priests tend to say it's spiritually dange
932.
▲
by
srcreigh
5y ago
The "Jump To Recipe" button on the Lasagna page took to straight to the ingredients
933.
▲
by
srcreigh
5y ago
Same with Toronto. It's really more like Turonno
934.
▲
by
srcreigh
5y ago
English. Emphasis on the ish.
935.
▲
by
srcreigh
5y ago
Do you pronounce it ayesthetic?
936.
▲
by
srcreigh
5y ago
https://news.ycombinator.com/item?id=29718254
937.
▲
by
srcreigh
5y ago
It's a side effect. Govt supported espionage monopolies (FB/Google) -> decreased competition and talent pool -> small services are worse for having less competition.
938.
▲
by
srcreigh
5y ago
Unregulated winner take all effects. Too many acquisitions - not enough competition. Giant companies providing market leading services at 3+ layers, increasing startup costs, enabling anti competitive behaviour. However I believe the true r
939.
▲
by
srcreigh
5y ago
Re; recipes, look for the "Jump to recipe" button. It's always there, you don't have to scroll.
940.
▲
by
srcreigh
5y ago
The submitted link should be changed to this, imo.
941.
▲
by
srcreigh
5y ago
It's actually a little more than 1 year - late 2020 to present
942.
▲
by
srcreigh
5y ago
Any reason to do this instead of multiple windows in a tiling WM?
943.
▲
by
srcreigh
5y ago
Blacklisting non advertisable media from the index. That's news to me. Hmm. Why? Cost savings? Missing hard dependency on marketing ops knowhow? Utter domination of non-marketing material? Forcing experienced privacy-conscious users to
944.
▲
by
srcreigh
5y ago
5-30 people in every high school is extremely rare?
945.
▲
by
srcreigh
5y ago
Jesus said we'll always have poor people. So you're not wrong. It doesn't have to be a solvable problem to be the best way to measure success. Your working definitions of "best" and "worst" still seem to b
946.
▲
by
srcreigh
5y ago
You'll have to follow the popularity trail further back to early 2010's Minecraft hunger games servers. (Rather I suppose the popular 2008 book The Hunger Games.)
947.
▲
by
srcreigh
5y ago
Racket has a first class SQL query DSL. [0] With some kinda dynamic naming system, you could probably load SQLite table schemas at runtime and provide bindings to columns automatically. Or maybe that's best done once at the compile ste
948.
▲
by
srcreigh
5y ago
We should reject this simply because it does not provide any clear benefits, but meanwhile asks for a lot. People to learn the FK names in their DB, people to learn new SQL syntax (and tooling to support it). It's actually difficult to
949.
▲
by
srcreigh
5y ago
A DB system that works for professionals and doesn't require any public ecosystem of training materials won't be mentioned much in public.
950.
▲
by
srcreigh
5y ago
What do temporal tables do that good queries don't?
951.
▲
by
srcreigh
5y ago
Relational data schemas are a graph
952.
▲
by
srcreigh
5y ago
You're basically talking about Airflow/Airbyte/custom ETL + database expertise. The only way to get efficient performance is expertise, expertise is expensive, ETLs are a given when you have expertise... Just hire a DB consul
953.
▲
by
srcreigh
5y ago
Is this ranking by # of orgs using Postgres, or relative total company value using Postgres, or some even more ambiguous effectiveness metric? Answer: https://db-engines.com/en/ranking_definition
954.
▲
by
srcreigh
5y ago
Clustered indexes?
955.
▲
by
srcreigh
5y ago
I always use regexp-replace for this. There's an incrementing counter for regexp-replace, a way to manually enter a part of each replacement, and other goodies. Personally I only use capture groups, no counters or other stuff. I do lik
956.
▲
by
srcreigh
5y ago
Did you try SSH and using SQLite command line tool?
957.
▲
by
srcreigh
5y ago
There is a diff tool [0], and an online backup tool [1]. That kinda thing should be pretty easy to cobble together. You'll just need ~3x disk space to store 2 backups at an interval, diff them and discard the older backup, then apply b
958.
▲
by
srcreigh
5y ago
There is no concurrent writing with WAL mode
959.
▲
by
srcreigh
5y ago
In WAL mode, a write can mean writing some data in memory on the local machine. With Postgres/MySQL/etc, it has to go over the network. I can't parse [0] right now about the overhead of TCP and round trips with the database s
960.
▲
by
srcreigh
5y ago
More info about WAL mode concurrency [0] No reader-writer lock. Still only 1 concurrent writer, but write via append to WAL file is cheaper. Can adjust read vs write performance by syncing WAL file more or less often. Can also increase perf
More ›