aanari | 2 years ago | on: Show HN: I built a multiplayer voxel browser game engine
Awesome work!
aanari's comments
aanari | 6 years ago | on: Show HN: Instantly make any Netlify form PCI DSS compliant
Nice work VGS team!
aanari | 7 years ago | on: Ask HN: Interest in biotech investing course?
I am extremely interested!
aanari | 7 years ago | on: 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.
aanari | 8 years ago | on: Cowboy 2.0 released
Awesome Cieplak, best of luck to you and the team @ Finix!
aanari | 10 years ago | on: 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 :)
aanari | 11 years ago | on: 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.
aanari | 11 years ago | on: 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.
aanari | 11 years ago | on: PostgreSQL Data Migration Tips
No problem mizerable! Glad you enjoyed it.
aanari | 11 years ago | on: 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).
aanari | 11 years ago | on: PostgreSQL Data Migration Tips
Author here. Great point, I just updated this link to point directly to his comment rather than his HN profile.
aanari | 12 years ago | on: Lessons learned publishing my first CPAN module
That's a great point tantalor, thanks for sharing.
aanari | 12 years ago | on: Lessons learned publishing my first CPAN module
Hello, author here,
I recommend App::pmuninstall for this task:
pm-uninstall [options] Module
page 1