HN user
All I can think of is image generation of potential targets like ships, airplane, airfield and feed them to their satellite or drones for image detection and tweak their weapons for enhance precision.
Your hiring page is so cool! Love it!
oh no wonder they had a billing outage.
You offload some load like pg connections from postgres to redis. Your pg shared buffers would also be available for other stuff.
Ars longa, vita brevis
"skilfulness takes time and life is short"
Also if you can add amazon memory db to yor list of benchmarks, would also be interested to know more.
no wonder my builds are all failing..
Something I've wanted to comment on this as well. It's best to use render_template() when rendering the views so it doesn't tangle w/ a lot of python controller logic.
I've been using my own audit trigger for 3 years now.
https://github.com/cmabastar/audit-trigger
It uses the old and tested http://wiki.postgresql.org/wiki/Audit_trigger_91plus
but with JSONB instead of HSTORE, and automatically creates partitioned tables by month (Requires PG11+).
curious to know what instance type are you using for AWS? Are they i3 instances?
I'm loving htmx! as backend developer this just eliminates all the js monstrosity of packaging, dependencies and deployments..
We are using it on our PoC products. It's really great and fast! it removes all the traction of doing an autocomplete search.
https://correlate.meetglimpse.com/
If you're doing some test products and just want to have a search that is easier to setup than ES. Meilisearch is a great alternative.
Looks cool!
Where is my minesweeper and freecell?
For simple task queues, yes pg is ok. For high loads, redis is still better as PG generates a lot of WAL & connection overhead.
Using a different setup for deploying client side static html.
- React/ Js framework
- Deploy Static Files to S3
- Cloudfront for cdn
- Cloudflare pointing to cloudfront cdn
- Cloudfare Page rules for protected sites / no need create login/auth
- Flask
- Postgres
Thanks for the hardwork zzzeek! I've been using sqlalchemy for 5+yrs now and it's great to work with!
I like SQL and I like the ORM. When things go tough like doing complicated JOINs or OLAP. I just go raw sql. If it's OLTP, updates and simple lookups, ORM makes the code readable.
The alembic migration is also great! I can craft the models to design with postgres features (index, multi key index, pk uuid) and etc..
I'd would love sqlalchemy to invest more on scaling. Although scaling is an entire book of discussion. Not much resources are there for handling multiple db, sharding (maybe too much to ask).
My opinion is, love SQL and Love the ORM. You'll need both to appreciate it's power. It's like learning VIM, a long term investment tool and hard to :wq
Not the world, but the universe!
Loving how zfs is so easy once you get a hang of it.
I'm trying to test it out on an i3a.large instance with 1.2TB NVME ssd and benchmarking postgres on it. Trying to move out of RDS since time to time I have an heavy iops scripts.
Only thing left is doing zfs snapshots next for my backups. zfs snapshots or pg_dump snapshots? I wonder what's better.
By any chance did you get inspired from this thread?
Great work postgres team!
Can confirm the experience, I had to work on a company before with similar tech using Django.
https://github.com/bernardopires/django-tenant-schemas
All I can say, that it was a nightmare to do deployment and migration and some backward incompatibility features restrained us in some ways.
The company valued data isolation as a priority rather than ease of developing it. Hard to work with but great for data isolation.
Exactly it's a bit more of work does make you prone to mistakes. This is what happens when you rewrite transaction on your application. See what happens with to a btc exchange using mongo who got hacked.
https://dzone.com/articles/mongodb-bitcoin-how-nosql (article is 2014)
I'm a bit outdated with mongo since 2.4-2.6 . It's a bit traumatic and i'm never coming back to it.
If in case I'll need a high atomicity and consistency for financial transaction i'll just use postgres with SERIALIZABLE transaction isolation. This solves everything.
Checkout the redbook.io it's a bit outdated but you can see from stonebreaker's discussion that nosql + sql will merge, which is what happening or happened right now. Mongo having transaction, and SQL having json datatypes.
back when mongo was around 2.6x, they had a global write lock.
Also, you'll encounter more problems with mongodb if in case you need transaction. You should check out more discussion here on db systems.
How does Thinkpad compare to the trackpad of mac nowadays?
The only thing that makes me use mac is the trackpad and retina. I have 15" late 2015 mbp, so far the best mbp out there w/o the butterfly keyboard.
Im still considering to go back to thinkpad for my next laptop since i had t42p, t60 before.
working on a graph tool similar to google trends but for reddit. It's still in alpha stage.
Redis tests are written in tcl! both perl and tcl are awesome!
Angular - Still lost track w/ their versioning. React - More popular JS Postgres - Getting better and better Svelte - Might make it. K8s - Too much stuff going on. Jump w/ care.
I think it applies to all open source projects.
100000 / 30 / 24 / 60 / 60 = .03 views per sec.
Nothing surprising here.
But a great blog overall!
loved the improvements! More power to the pg team!