Spixel_'s comments

On: Show HN: SQL-tap – Real-time SQL traffic viewer for PostgreSQL and MySQL

[Spixel_]

Maybe consider renaming this since pgTAP [0] exists and has nothing to do with this.

[0]: https://pgtap.org/

On: SQL needed structure

[Spixel_]

I don't get the transaction bit. At least with postgres, a transaction doesn't guarantee that all statements in it see the data at the same point in time (actually, it's not even guaranteed for subqueries).

Also, often, the transactional database servers is more difficult to scale than application servers so from a technical standpoint, it makes sense to do this glue work in app code.

[andyferris → Spixel_]

> a transaction doesn't guarantee that all statements in it see the data at the same point in time

This depends on the transaction isolation level. If you use snapshot or serializable this should be the case (but you may have aborted transactions due to optimistic concurrency).

[Spixel_ → andyferris]

You are right, but note that the default isolation level is "Read committed" in postgres.

[TheTaytay → Spixel_]

Doesn’t it guarantee consistency from the time the transaction started (assuming read committed isolation)? It guarantees you won’t see something “later” than when your transaction began.

https://www.postgresql.org/docs/current/transaction-iso.html

I’m likely misunderstanding what you mean by time.

[Spixel_ → TheTaytay]

Read committed (which is the default), doesn't guarantee that. See "Nonrepeatable Read" and "Phantom Read" which are both possible in your documentation page.

[Jweb_Guru → Spixel_]

SSI scales fine for most workloads as long as you correctly mark your read-only transactions.

On: Next.js 14

[Spixel_]

We migrated to Remix a few months ago, never going back.

On: Next.js 14

[Spixel_]

That would be Remix: https://remix.run

See: https://www.epicweb.dev/why-i-wont-use-nextjs

On: Absolute truths I unlearned as junior developer (2019)

[Spixel_]

Comments aren't bad per se, but they should explain Why vs. How.

On: Crabs evolved at least five times from separate groups of crustaceans (2021)

[Spixel_]

You should play Obra Dinn.

On: Python Coding Style Compliance on Stack Overflow

[Spixel_]

> Given how much programming now consists of "copy, paste, and modify," enforcing style conventions on Stack Overflow might do more to improve general coding standards than anything else we could try.

I'm guessing most of developers use a formatter like black [0] nowadays so that will have less and less impact.

[0]: https://github.com/psf/black