wild_egg

19 ms·

361.
by wild_egg 2y ago
Maybe dumb question but why is keeping a million booleans in one process un-scalable? That's only 125KB of memory which can easily live inside CPU cache and be operated on atomically.
362.
by wild_egg 2y ago
Any hints on how to even begin looking into this? There's a plethora of content on starting SaaS projects but can't say I've ever come across any for hardware.
363.
by wild_egg 2y ago
Not sure where you're getting those requirements from — message queues were called out specifically in TFA and async workflows are trivial to build on top without instantly reaching for Kafka The "just use postgres" mantra ca
364.
by wild_egg 2y ago
I hadn't but would now like to
365.
by wild_egg 2y ago
Have you seen this done anywhere? I have to wonder if it would even have any impact
366.
by wild_egg 2y ago
Not near a computer to try this out but I'd be surprised if you couldn't get a huge speed up by selecting the whole file into a real table first and querying against that. DuckDB should be able to better vectorize operations then
367.
by wild_egg 2y ago
This is excellent — do you have any content around the performance affect here over using SQLite directly? I could see DuckDB's engine being faster for some cases but the SQLite storage format might hinder it. Curious if there's a
368.
by wild_egg 2y ago
Are we certain that it's _not_ a decent choice for a typical web app? I'm tempted to swap it into one of mine and see how it behaves. Even if some operations are internally slower, that might be offset by having zero network laten
369.
by wild_egg 2y ago
Anyone know of an example of any other style? Would love to see any half-baked experiments even. Seems like a space that could really use some innovation
370.
by wild_egg 2y ago
_should_ know is different than _do_ know. Most engineers have little to no understanding of those systems topics and the only DB knowledge they've picked up is what leaks through their ORM A person who competently knows all those topi
371.
by wild_egg 2y ago
I've always used !$ to get the last word of the previous command like so: mkdir -p foo/bar cd !$ # => cd foo/bar I suppose the advantage of `ESC, .` is universality since it'd work inside any rea
372.
by wild_egg 2y ago
Service workers seems like overkill HTMX has pretty simple controls for pushing history state from either the client or the server for each request. Add the current page into the URL every time you load a new section and when someone hits &
373.
by wild_egg 2y ago
> every single interaction requires a separate round-trip HTTP request Why? It's not like JavaScript stopped existing. If you need something more interactive or dynamic, use JS. The two approaches are not exclusive. Some things can
374.
by wild_egg 2y ago
> Fast and clean template engine Is PHP not already a template language? The whole idea of PHP frameworks always confused me. Why do I need a router when I can simply add new files at the routes I want?
375.
by wild_egg 2y ago
When in doubt, just use postgres. It can handle everything you might want from either MySQL or MongoDB and take you to a scale where you can afford to pay someone to figure out a more appropriate stack for your needs
376.
by wild_egg 2y ago
Article source seems to be mainly an ad for some agile alternative which makes the whole thing suspect. Most of the "results" can boil down to: scope creep kills projects. That's entirely independent of whatever methodology y
377.
by wild_egg 2y ago
Why could you not join with the audit table and find historical billing information from the old CPRs?
378.
OtterTune officially shutting down services(ottertune.com)
3 points by wild_egg 2y ago|0 comments
379.
by wild_egg 2y ago
Not talking about spark clusters anywhere here. I wouldn't be surprised if that's similar in cost to snowflake. What I'm talking about is snowflake vs a $50 EC2 instance running DuckDB reading data from S3. Try it out sometim
380.
by wild_egg 2y ago
Not a whole lot of operational difference between sending them a snowflake view name or sending an S3 URL but there's probably two orders of magnitude cost difference
381.
by wild_egg 2y ago
You then also have to mail them every update to the SQL and hope they're handling versioning well With this approach, next time they attach the DB, they automatically see the latest version
382.
by wild_egg 2y ago
TCP handshake failure prevents the client from being able to send any data, no?
383.
by wild_egg 2y ago
I'm not sure if it's just sugar but PostgreSQL does allow subscripting on JSONB in UPDATE statements UPDATE characters SET jsonb_column['superpower'] = '"invisibility"' WHERE id = 5;
384.
by wild_egg 2y ago
Does MongoDB still throw safety out the window to win benchmarks? I'll give you that the postgres query operators for JSON can be cumbersome, depending on your library support, but JSONB performance has been rock solid for a long time
385.
by wild_egg 2y ago
It's been a long time since I've used python but that sounds like buffering in the library maybe? I use it from Go and it seems to behave differently. When I'm writing to postgres though I'm doing into entirely inside Du
386.
by wild_egg 2y ago
Have you given DuckDB a try? I'm using it to shuttle some hefty data between postgres and some parquet files on S3 and it's only a couple lines. Haven't noted any memory issues so far
387.
by wild_egg 2y ago
I don't think I've ever seen a ticket to write docs get prioritized. The backlog is just another void that happens to make people feel like they're doing something useful
388.
by wild_egg 3y ago
What happened to cache invalidation?
389.
by wild_egg 3y ago
Nightmare generated code is fine if you never have to look at it. This is like saying we shouldn't use react because of the div soup it spits out. We should be able to have modern tools that don't require spelunking in their outpu
390.
by wild_egg 3y ago
> A better model is to ditch the project manager and give the engineering manager an administrative assistant. Do you have any examples of this in practice? I've never seen an EM with an actual assistant before but this actually see

More ›