aanari
Re:Show HN: I built a multiplayer voxel browser game engine
on Tuesday April 25, 2023 @06:42PM (#35707713)
Awesome work!
Re:Show HN: Instantly make any Netlify form PCI DSS compliant
on Friday June 21, 2019 @02:14AM (#20240261)
Nice work VGS team!
Re:Ask HN: Interest in biotech investing course?
on Tuesday January 15, 2019 @01:33AM (#18909219)
I am extremely interested!
Re:Ask HN: Has anyone managed to regain their attention span/ability t...
on Monday November 12, 2018 @02:02AM (#18431041)
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.
Re:Cowboy 2.0 released
on Thursday October 05, 2017 @01:46AM (#15406880)
Awesome Cieplak, best of luck to you and the team @ Finix!
Re:ShaderFrog: Create complex, beautiful shaders with no code
on Tuesday September 08, 2015 @12:17PM (#10186584)
Great concept + execution! Can't wait to see the export functionality and for it to start gaining momentum in the market :)
Re:PostgreSQL Data Migration Tips
on Thursday March 19, 2015 @03:09PM (#9233928)
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.
Re:PostgreSQL Data Migration Tips
on Thursday March 19, 2015 @03:05PM (#9233908)
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.
Re:PostgreSQL Data Migration Tips
on Thursday March 19, 2015 @12:54PM (#9233193)
No problem mizerable! Glad you enjoyed it.
Re:PostgreSQL Data Migration Tips
on Thursday March 19, 2015 @12:53PM (#9233187)
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).
Re:PostgreSQL Data Migration Tips
on Thursday March 19, 2015 @12:49PM (#9233148)
Author here. Great point, I just updated this link to point directly to his comment rather than his HN profile.
Re:Lessons learned publishing my first CPAN module
on Wednesday February 05, 2014 @07:44PM (#7187935)
That's a great point tantalor, thanks for sharing.
Re:Lessons learned publishing my first CPAN module
on Wednesday February 05, 2014 @02:48PM (#7186329)
Hello, author here,
I recommend App::pmuninstall for this task:
pm-uninstall [options] Module