Earlier quoted context omitted.
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.
I don't like the sql() helpers part, and that they try to guess whether I want a helper for insert or update, based on some regexes and that helpers for different things all are sql(something) while doing very different things. https://github.com/porsager/postgres/blob/master/lib/index.j... I also tend to compose queries out of smaller static parts dynamically, and tagged syntax does seem to make that hard. Patterns…
Ask HN: What are some tools / libraries you built yourself?
601–610 of 617 posts
Re: Ask HN: What are some tools / libraries you built yourself?
#602Earlier quoted context omitted.
I found that I wanted something really specific, and built a tool in Go that lets you write, modify and use plpgsql functions as if they were regular source code files rather than database objects. You can write them as Go packages, import those packages into other Go projects, and write tests - without maintaining migration files for anything other than the tables. Combined with IDEA’s plpgsql language support it’s…
can you give more details, i am generating golang and js functions corresponding to plpgsql functions in somewhat hacky way. I am curious to know what approach have you taken, is it something similar to this project https://github.com/gchaincl/dotsql
It would be great to generate Go stubs from the SQL definitions and I don't do that. I'd like something a bit like dotsql but ideally where it creates actual Go funcs out of the SQL function signatures.
The bit that I've done so far lets you package up SQL functions into a schema and treat them as a Go package. you can include them in go.mod and the functions are maintained without writing migration scripts.
I'm under the pump at the moment but I'll try to write something up about it and maybe ping you on github some time. Sorry i don't have much time at the moment!
Re: Ask HN: What are some tools / libraries you built yourself?
#603Early 2017, I built Listen Notes [1] , so I can search podcast episodes by keywords and listen to individual podcast episodes without subscribing to the entire podcast. A few years ago, most podcast apps assume you wanted to subscribe to podcasts first then listen. Maybe I’m not a typical podcast listener. I don’t like subscribing to podcasts. I just want to listen to individual episodes then move on. Similar to cons…
Re: Ask HN: What are some tools / libraries you built yourself?
#604Earlier quoted context omitted.
I don't like the sql() helpers part, and that they try to guess whether I want a helper for insert or update, based on some regexes and that helpers for different things all are sql(something) while doing very different things. https://github.com/porsager/postgres/blob/master/lib/index.j... I also tend to compose queries out of smaller static parts dynamically, and tagged syntax does seem to make that hard. Patterns…
That makes perfect sense. Thanks a lot for the feedback.
Re: Ask HN: What are some tools / libraries you built yourself?
#605I made a macOS script that OCRs text on screen. It is super handy for dealing with everything from scanned documents with account numbers to web pages with text in images. When I press F16, I get an image capture cursor, and the area selected is turned into text. Example: https://files.littlebird.com.au/Screen-Recording-2021-05-17-...
Edit: I'll clean the script up and make it available as a "Show HN:" soon.
Re: Ask HN: What are some tools / libraries you built yourself?
#606I built a really simple cloud watchdog using only free-tier services: http://www.watchdog.email/ https://github.com/jareklupinski/watchdog-email planning on adding a timeout parameter soon!
Maybe I missed it. But what use case is this for?
Re: Ask HN: What are some tools / libraries you built yourself?
#607Re: Ask HN: What are some tools / libraries you built yourself?
#608Earlier quoted context omitted.
As promised, the Show HN is available here: https://news.ycombinator.com/item?id=27227925
Thank you!
Re: Ask HN: What are some tools / libraries you built yourself?
#609I wanted a tool where multiple translators are integrated and where I can get translations from different sources but only using one tool. I then tried to build a cross platform mobile app using python (which is not the best language for this, I know) https://github.com/nidhaloff/Translator-pp
Probably the best project I built/started last year is the machine learning package igel: https://github.com/nidhaloff/igel
Re: Ask HN: What are some tools / libraries you built yourself?
#610https://github.com/inaka/worker_pool - A pool of workers
https://github.com/inaka/elvis_core - A linter for Erlang
https://github.com/adroll/rebar3_format - A formatter for Erlang
https://github.com/adroll/rebar3_hank - An oxbow code detector for Erlang