Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
geenat
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
15 ms
·
181.
▲
by
geenat
4y ago
I totally hear you, been down a similar path. As for the "huge chinese" databases, not to sound like a conspiracy, but CockroachDB has outperformed them in my server load testing (stress test with very basic "SELECT FROM user
182.
▲
by
geenat
4y ago
It's a great point- I've been looking into this path myself: ScyllaDB + logic inside app. The main issue I've run into is deployment. It's just very rough compared to CockroachDB or Postgres, which are single binary or v
183.
▲
by
geenat
4y ago
Speaking only for postgres 15+, but in my testing, app drivers have been great about facilitating "connection pooling" without a separate server. Eliminates connection overhead at the app level for many projects. Golang and ASGI P
184.
▲
by
geenat
4y ago
You'd certainly want to shard from the start in any case, but it's an order of magnitude less postgres boxes for the QPS.
185.
▲
by
geenat
4y ago
These numbers make more sense on hardware from 5 years ago (to be fair, what they were dealing with), but postgres, on modern consumer hardware (Yes, consumer! Ex: KC3000 + Ryzen 7950x), already does over 50k QPS without being overburdened.
186.
▲
by
geenat
4y ago
Compute on WebGPU is gonna be interesting- "crowd sourced" model training.
187.
▲
by
geenat
4y ago
Similar to how the upcoming WAL2 works in SQLite, could do it atomically or "concurrent safe" like: - Main count file. - 2 "Append" files. ====== - Append 'a' to append file 1. - After some time, swap append fi
188.
▲
by
geenat
4y ago
Bit of a nail in the coffin for me as of late. * No async drivers. * Total freezeup bug that only appears when MariaDB is under high load, since mid-2021 (10.6), not yet addressed. * Postgres 15 outperforming MariaDB in both my own SELECT a
189.
▲
by
geenat
4y ago
First they came for our staplers and now this.
190.
▲
by
geenat
4y ago
It's a big plus for library and FFI interop so external styles don't take over your entire project. Also, John Carmack: https://mobile.twitter.com/id_aa_carmack/status/159256093820...
191.
▲
by
geenat
4y ago
Always excellent to see Video Sequencer updates so we can eventually replace After Effects / Premiere
192.
▲
by
geenat
4y ago
Animated AVIF is nice.
193.
▲
by
geenat
4y ago
Ugh they removed Actionscript 2. Really disappointing. AS3 is a velocity killer.
194.
▲
by
geenat
4y ago
It was an art tool first and foremost. This idea directed every aspect of the UX. Basically Unity, but far less friction, less ceremony, less busywork. Often the primary tool of the artists themselves. Actionscript 2 would allow you to get
195.
▲
by
geenat
4y ago
Nothing has replaced Flash for low friction creative outlet for animations and games. Even artists could use Flash very effectively by themselves. The iteration time was mindblowing- Using Flash, I remember putting together Ludum Dare games
196.
▲
by
geenat
4y ago
Glass seemed so far ahead of it's time when one considers how much microsoft is investing into augmented reality and hololens.
197.
▲
by
geenat
4y ago
Gitea on SQLite for the ultimate ease of setup and maintenance. Version 19 is killer- Trello style image previews on issue cards / kanban board. Github actions! Also import / export from github / gitlab at any time.
198.
▲
by
geenat
4y ago
Github actions are supported in Gitea 19, yes.
199.
▲
by
geenat
4y ago
Gitea on SQLite for the ultimate ease of setup and maintenance. Version 19 is killer- Trello style image previews on issue cards / kanban board! Also import/export to github / gitlab at any time.
200.
▲
by
geenat
4y ago
I'm the author of https://github.com/gnat/sublime-python-html-sql Just was curious if anyone solved this DX issue in a more elegant way.
201.
▲
by
geenat
4y ago
Of course. I'm referring to HTML syntax in python string highlighting in your editor. How is support for that? Recommended plugins?
202.
▲
by
geenat
4y ago
How is HTML syntax highlighting in strings?
203.
▲
by
geenat
4y ago
Intermittent fasting to lose, keto to maintain. Abs are made in the kitchen. Calories in vs calories out. Gym is good for tone and breaking a plateau, but you aren't likely to lose a lot in the gym only without a CICO change. Went from
204.
▲
by
geenat
4y ago
Thanks. First thing I look for when looking at new editors. Electron leads to high latency and slowdown once your editor grows big enough- even on 8+ core machines. We have so many electron based editors at this point, including incumbent V
205.
▲
by
geenat
4y ago
Sounds like non-destructive editing should come out in late 2050 (or 2060), which would be cool
206.
▲
by
geenat
4y ago
Non-blocking I/O is essential for high throughput, but high latency internet native databases such CockroachDB.
207.
▲
by
geenat
4y ago
Wall of text. Less is more. Non-blocking I/O is wonderful news though, especially for high throughput yet high latency internet native databases such CockroachDB.
208.
▲
by
geenat
4y ago
Essential: * Flicker free monitor (non-PWM backlight). * Dark Reader browser plugin. Nice to have: * Ambient lighting. * Curved monitors (reduces constant eye re-focusing on large monitors). * Matte finish on monitors, avoid glass to avoid
209.
▲
by
geenat
4y ago
I find it crazy how many people in here still believe these AI's are producing totally original works- the main source images are all ripped from art station and the like. Midjourney is painfully obvious in its use of the same limited
210.
▲
by
geenat
4y ago
As someone who started in video game development... ...beyond trivial stuff like pong, the natural pattern is just a big collection of state machines (as entities) interacting with each other.
More ›