Ask HN: What are some tools / libraries you built yourself?

Post by iamwil » Tue, May 18, 2021, 10:43 PM UTC

slmjkdbtl wrote: post #571

iamwil wrote: post #569

Earlier quoted context omitted.

I have thought about gamification, but I wasn't sure how you could verify the picture of the fish people posted was the actual fish. At best, people would play against themselves, just a collections game. Do you mean a made-up fantasy lore? Or actual background on the fish? What kind of stats?

I'm not a big sushi person, but stats could be stuff like freshness, juiciness, visual attractiveness, price, etc. Doesn't have to be that accurate but I think it'll add some appeal to the Torodex. Lore could be just a description, if there's any history to this specific dish, what it's made of and how it's made, etc. and yeah could add some jokes / fantasy lore just to spice it up. Mainly I'm hoping these sushis are…

Post by andrey_utkin » Wed, May 19, 2021, 8:29 AM UTC

mvolfik wrote: post #550

andrey_utkin wrote: post #354

Wearable computer (on-body Linux) with audial calendar reminders and "normal" hand-strapped "desktop" https://github.com/andrey-utkin/wearable-computer/wiki TODO list and personal project tracker - like TaskWarrior but SQL-accessible https://github.com/andrey-utkin/taskdb/wiki sqlhub.net - Access to public datasets in form via PostgreSQL server https://github.com/sqlhub-net/sqlhub-net/wiki

you mention "text message to miband 3" - did you, by chance, make MiBand hackable?

Post by piotrkaminski » Wed, May 19, 2021, 1:04 PM UTC

apuchitnis wrote: post #595

piotrkaminski wrote: post #577

Earlier quoted context omitted.

Thanks! I agree that I suck at marketing and would love to hand that job off to somebody with more skill. :)

I'm by no means an expert - only a beginner when it comes to this - but I'm happy to help if I can :) Just let me know!

Post by DreamScatter » Thu, May 20, 2021, 2:36 AM UTC

Post by megous » Thu, May 20, 2021, 8:43 AM UTC

porsager wrote: post #301

megous wrote: post #256

Earlier quoted context omitted.

Very nice! I'd ditch pg-promise in a heartbeat for something simpler. I kinda dislike the tagged template literal helpers magic. I'd be more comfortable with explicit references to substituted arguments. Though it seems like I can just use the unsafe api all the time for that. The rest of the API is very nice, .stream, .cursor, notify support, all that.

Thanks! I'm curious - What's the reason you don't like the tagged template literal? It's those that give you implicit safe parameters and let's you avoid doing parameter counting when writing queries.

    let params = {};
    let conds = ['TRUE']
    if (some_user_input) {
      conds.push('a = $test');
      params.test = some_user_input;
    }

    db.query(`
       SELECT cols, ... FROM xxx
       WHERE abc AND ${conds.join(' AND ')}
    `, params);