porsager (u/porsager)

porsager commented on iPhone Typos? It's Not Just You – The iOS Keyboard Is Broken [video] youtube.com/watch?v=hksVv... · Posted by u/walterbell

dbmnt · 13 days ago

I just installed it and it seems really promising. Glad you shared it here.

I’ve spent more time than I care to admit searching for a good keyboard app in the App Store, and I’ve tried a lot of them. This one never surfaced for me in any of my usual searches, which is a shame (likely more on Apple’s search than on you).

I really like the T9-style approach, and I appreciate the clean App Privacy section and straightforward privacy policy.

porsager · 13 days ago

Thanks a lot! I haven't done much on the marketing side, but I always felt it had great potential.

It needs a little tlc to align with the latest iOS update changes, but my time is too limited at the moment.

porsager commented on iPhone Typos? It's Not Just You – The iOS Keyboard Is Broken [video] youtube.com/watch?v=hksVv... · Posted by u/walterbell

porsager · 13 days ago

Shameless plug, but back in 2014 trying to play with swift I made Type Nine, and I'm still using it to this day[1]

I also did a few other experiments that I unfortunately haven't had time to explore further[2]

[1] https://www.typenineapp.com

[2] https://medium.com/porsager/a-better-iphone-typing-experienc...

porsager commented on Denmark's government aims to ban access to social media for children under 15 apnews.com/article/denmar... · Posted by u/c420

davzie · 2 months ago

You can really tell the parents vs non-parents in these comments.

porsager · 2 months ago

Indeed.. All those people that have kids but are not fit to be called a parent so they need the government to do their job!

porsager commented on Denmark's government aims to ban access to social media for children under 15 apnews.com/article/denmar... · Posted by u/c420

trey-jones · 2 months ago

As a parent who gave my oldest child a (very used) smartphone just before she turned 14, I would be in favor of making smartphones illegal under age 15 (or some other number, higher or lower I don't care). I'm pretty sure they're worse than cigarettes for the future of humanity.

porsager · 2 months ago

If you're a parent then act like one. You're perfectly able to enact that ban yourself - why do you need the governments help?

porsager commented on Pipelining in psql (PostgreSQL 18) postgresql.verite.pro/blo... · Posted by u/tanelpoder

hombre_fatal · 2 months ago

That was a pretty nasty assumption you made about them though: That they're MIA because they're upset that their pet project isn't as popular as they'd like.

Jeez.

That said, I hope node-postgres can support this soon. As it stands, every single query you add to a transaction adds a serial network roundtrip which is devastating not just in execution time but how long you're holding any locks inside the transaction.

porsager · 2 months ago

Hehe. I didn't read it like that at all, so no worries

porsager commented on Pipelining in psql (PostgreSQL 18) postgresql.verite.pro/blo... · Posted by u/tanelpoder

stephen · 2 months ago

Oh hello! Very happy to hear from you, and even happier to be wrong about your "AWOL-ness" (since I want to ship postgres.js to prod). :-)

My assumption was just from, afaict, the general lack of triage on GitHub issues, i.e. for a few needs we have like tracing/APM, and then also admittedly esoteric topics like this stack trace fixing:

https://github.com/porsager/postgres/issues/963#issuecomment...

Fwiw I definitely sympathize with issue triage being time-consuming/sometimes a pita, i.e. where a nontrivial/majority of issues are from well-meaning but maybe naive users asking for free support/filing incorrect/distracting issues.

I don't have an answer, but just saying that's where my impression came from.

Thanks for replying!

porsager · 2 months ago

Thanks a lot. You're spot on about issue triage etc. I haven't had the time to keep up, but I read all issues when they're created and deal with anything critical. I'm using Postgres.js myself in big deployments and know others are too. The metrics branch should be usable, and I could probably find time to get that part released. It's been ready for a while. I do have some important changes in the pipeline for v4, but won't be able to focus on it until December.

porsager commented on Pipelining in psql (PostgreSQL 18) postgresql.verite.pro/blo... · Posted by u/tanelpoder

stephen · 2 months ago

I really want to use pipelining for our "em.flush" of sending all INSERTs & UPDATEs to the db as part of a transaction, b/c my initial prototyping showed a 3-6x increase:

https://joist-orm.io/blog/initial-pipelining-benchmark/

If you're not in a transaction, afaiu pipelining is not as applicable/useful b/c any SQL statement failing in the pipeline fails all other queries after it, and imo it would suck for separate/unrelated web requests that "share a pipeline" to have one request fail the others -- but for a single txn/single request, these semantics are what you expect anyway.

Unfortunately in the TypeScript ecosystem, the node-pg package/driver doesn't support pipelining yet, instead this "didn't quite hit mainstream adoption and now the author is AWOL" driver does: https://github.com/porsager/postgres

I've got a branch to convert our TypeScript ORM to postgres.js solely for this "send all our INSERTs/UPDATEs/DELETEs in parallel" perf benefit, and have some great stats so far:

https://github.com/joist-orm/joist-orm/pull/1373#issuecommen...

But it's not "must have" for us atm, so haven't gotten time to rebase/ship/etc...hoping to rebase & land the PR by eoy...

porsager · 2 months ago

I'm right here - what are you missing?