Hacker News Reader

aanarion Show HN: I built a multiplayer voxel browser game engine

Awesome work!

aanarion Show HN: Instantly make any Netlify form PCI DSS compliant

Nice work VGS team!

aanarion Ask HN: Interest in biotech investing course?

I am extremely interested!

aanarion Ask HN: Has anyone managed to regain their attention span/ability to focus?

Nootropics can help with this too esp. as you get older -

www.getmindsync.com

DM me if you would like to try some for free.

aanarion Cowboy 2.0 released

Awesome Cieplak, best of luck to you and the team @ Finix!

aanarion ShaderFrog: Create complex, beautiful shaders with no code

Great concept + execution! Can't wait to see the export functionality and for it to start gaining momentum in the market :)

aanarion PostgreSQL Data Migration Tips

That's correct, as jpitz mentioned if the code is run inside a transaction block, then we don't have to worry about the failing DELETE causing the INSERTs to fail.

aanarion PostgreSQL Data Migration Tips

Author here. That's a great point bhahn, I just updated my gist to properly handle the case that you just outlined:

https://gist.github.com/aanari/349c7d97ed50c6f69930#file-bat...

By creating a separate function for the locking and updating of rows, we ensure that the `BEGIN/END` transaction is handled per iteration rather than at the very end, so we only lock rows while they are being processed. Since Postgres does not support nested transaction blocks, calling a defined function from within an anonymous function block seemed to be the easiest and clearest path to achieve this.

aanarion PostgreSQL Data Migration Tips

No problem mizerable! Glad you enjoyed it.

aanarion PostgreSQL Data Migration Tips

That's a good clarification. I think it's better for the data migration to error out when acquiring the lock on rows and then retry, rather than waiting indefinitely, but YMMV (your mileage may vary).

aanarion PostgreSQL Data Migration Tips

Author here. Great point, I just updated this link to point directly to his comment rather than his HN profile.

aanarion Lessons learned publishing my first CPAN module

That's a great point tantalor, thanks for sharing.

aanarion Lessons learned publishing my first CPAN module

Hello, author here,

I recommend App::pmuninstall for this task:

pm-uninstall [options] Module

https://metacpan.org/pod/pm-uninstall