qatanah's comments

qatanah | 10 months ago | on: OpenAI releases image generation in the API

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.

qatanah | 1 year ago | on: Ask HN: Who is hiring? (April 2024)

Your hiring page is so cool! Love it!

qatanah | 2 years ago | on: Ask HN: Did you encounter any leap year bugs today?

oh no wonder they had a billing outage.

https://www.cloudflarestatus.com/

qatanah | 3 years ago | on: Just use Postgres for everything

You offload some load like pg connections from postgres to redis. Your pg shared buffers would also be available for other stuff.

qatanah | 3 years ago | on: Ask HN: I want to be an expert in many things but my lifetime won't be enough

Ars longa, vita brevis

"skilfulness takes time and life is short"

https://en.wikipedia.org/wiki/Ars_longa,_vita_brevis

qatanah | 3 years ago | on: Redis vs. KeyDB vs. Dragonfly vs. Skytable

Also if you can add amazon memory db to yor list of benchmarks, would also be interested to know more.

https://aws.amazon.com/memorydb/

qatanah | 3 years ago | on: PyPI loops on redirect while downloading dependencies

no wonder my builds are all failing..

qatanah | 3 years ago | on: Building a fullstack app with Flask and Htmx

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.

qatanah | 4 years ago | on: Postgres Auditing in 150 lines of SQL

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+).

qatanah | 4 years ago | on: We saved millions in SSD costs by upgrading our filesystem

curious to know what instance type are you using for AWS? Are they i3 instances?

qatanah | 4 years ago | on: How Laravel Livewire works

I'm loving htmx! as backend developer this just eliminates all the js monstrosity of packaging, dependencies and deployments..

qatanah | 4 years ago | on: MeiliSearch: A Minimalist Full-Text Search Engine

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.

qatanah | 4 years ago | on: Windows 96

Looks cool!

Where is my minesweeper and freecell?

qatanah | 4 years ago | on: Do you really need Redis? How to get away with just PostgreSQL

For simple task queues, yes pg is ok. For high loads, redis is still better as PG generates a lot of WAL & connection overhead.

qatanah | 4 years ago | on: Ask HN: What novel tools are you using to write web sites/apps?

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

qatanah | 5 years ago | on: Migrating to SQLAlchemy 2.0

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

qatanah | 5 years ago | on: New 10 Terapixel Image of the Night Sky Contains 1B Galaxies

Not the world, but the universe!

qatanah | 5 years ago | on: An Introduction to ZFS

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.

qatanah | 5 years ago | on: Show HN: A simple SSH CA service with only 150 lines of Python code

By any chance did you get inspired from this thread?

https://news.ycombinator.com/item?id=24157180

qatanah | 5 years ago | on: PostgreSQL 13

Great work postgres team!