porsager

15 ms·

1. 151.▲
   by porsager 5y ago

   Wow - thats awesome! Thank you!
2. 152.▲
   by porsager 5y ago

   Haha.. There's plenty of us out there, it's probably just that we'd rather do actual stuff than talk about doing it. A bit like Typescript - it doesn't really do anything, it just talks about it. Joking aside, I generall
3. 153.▲
   by porsager 5y ago

   Yeah, just make a simple query :) await sql`select 1`
4. 154.▲
   by porsager 5y ago

   I think you're right. Here's a project proving the exact opposite of native bindings being slow - https://github.com/uNetworking/uWebSockets.js
5. 155.▲
   by porsager 5y ago

   The results are run through the same tests ;)
6. 156.▲
   by porsager 5y ago

   That's interesting - haven't heard of that issue before, so do please create an issue on github or let me know if you figure it out ;)
7. 157.▲
   by porsager 5y ago

   Alright. I've got a pg wrapper lying around that can help with migration I can send you ;) I've DM'ed you on twitter, so let me know if that could be useful.
8. 158.▲
   by porsager 5y ago

   Thanks a lot. I did not built it with Typescript, just plain js - I don't use Typescript at all(not my cup of tee), but a kind soul (thanks @minigugus) contributed the typings ;) I actually began it out of curiosity and because I was m
9. 159.▲
   by porsager 5y ago

   Yeah, I think it could make sense for performance reasons to make a version for Knex, but since I try to stay away from ORMs as much as possible I'm probably not the right one to make it ;) I also wouldn't put it in the core libra
10. 160.▲
    by porsager 5y ago

    I actually replaced WTFPL with Unlicense since someone at google couldn't use it, so I would think it's ok?
11. 161.▲
    by porsager 5y ago

    Hey - that's pretty nice :) Didn't think of trying that - curious if it includes the cjs and esm version in the sum, since that's double of almost identical code.
12. 162.▲
    by porsager 5y ago

    There is quite a big difference, but I'll highlight some of the main points here. Note I'm the author of Postgres.js so I'm obviously biased. Slonik is a wrapper around another node driver (pg), so it's performance is th
13. 163.▲
    by porsager 5y ago

    It leverages pipelining and implicitly creates prepared statements. And I've spent quite some time optimizing the js code and parsing.
14. 164.▲
    by porsager 5y ago

    Thanks. Definitely production ready, and I've been using it for quite a while in production myself, towards this release. About the ORM layer I wouldn't know, since I much prefer to avoid that at any cost.
15. 165.▲
    by porsager 5y ago

    No, that unfortunately didn't make it into this release. I want to add that in a future update, first at least for bytea, but then also for other types that benefit from it.
16. 166.▲
    by porsager 5y ago

    Slonik is a wrapper around another Node.js postgres driver (pg). I guess slonik could be built on top of Postgres.js, but I'm not sure what the benefit would be since you get the same and more from Postgres.js. If you have an existing
17. 167.▲
    by porsager 5y ago

    Yeah, when a function is called as a "tagged template literal"[1] the function takes control over how the parameters are handled. Postgres.js uses this to replace the value with $1, $2, etc and send over the value as parameters to
18. 168.▲
    by porsager 5y ago

    Thanks a lot! What a coincidence - and perfect timing since v3 supports .raw()[1] to receive results as arrays. I'd also be very curious to hear how replacing pg goes :) And also good job on Imba! I'm a really big fan of stripping
19. 169.▲
    by porsager 5y ago

    Thanks - that's really nice to hear! That would be really interesting. Are you using `pg` currently, and are you using WebSocket connections in Node to Elixir for realtime, or not using realtime in Node?
20. 170.▲
    by porsager 5y ago

    Hi everyone. A bit more than two years ago I released the first version of Postgres.js. A fully featured PostgreSQL driver for Node.js written as a learning experience out of curiosity and annoyance with the current options. It greatly out
21. 171.▲
    Show HN: Postgres.js – Fastest Full-Featured PostgreSQL Client for Node and Deno(github.com)

    257 points by porsager 5y ago|83 comments
22. 172.▲
    by porsager 5y ago

    I created an enhanced multilingual T9 keyboard[1][2] for iOS in 2014 to play around with Swift. It's been doing 600$ on average since then, still going strong. Still use it everyday myself and can't live without it [1] https:&#x2
23. 173.▲
    by porsager 5y ago

    Interesting! I hope it can work out well for him - would love to hear about his experience if he gives it a shot. I've gotten good feedback from low vision and blind users, but I've also done my best trying to support VoiceOver in
24. 174.▲
    by porsager 5y ago

    I created an enhanced multilingual T9 keyboard[1][2] for iOS in 2014 to play around with Swift. It's been doing 600$ on average since then, still going strong. Still use it everyday myself and can't live without it [1] https:&#x2
25. 175.▲
    Syng – The world's first Triphonic speaker.(syngspace.com)

    1 points by porsager 5y ago|0 comments
26. 176.▲
    Tomorrow NASA launches DART to redirect the course of an asteroide(nasa.gov)

    5 points by porsager 5y ago|0 comments
27. 177.▲
    Aggregating NBA Data, PostgreSQL vs. MongoDB (2014)(tapoueh.org)

    3 points by porsager 5y ago|0 comments
28. 178.▲
    Who Needs Process? (2012)(widgetsandshit.com)

    6 points by porsager 5y ago|1 comments
29. 179.▲
    A simple extension to PostgreSQL that requires WHERE for UPDATE and DELETE(github.com)

    3 points by porsager 5y ago|0 comments
30. 180.▲
    Does Visual Studio Rot the Mind? (2005)(charlespetzold.com)

    1 points by porsager 5y ago|0 comments