Live data from Hacker News

Ask HN: What small library or tool do you want that doesn’t exist?

news.ycombinator.com

11–20 of 145 posts

Re: Ask HN: What small library or tool do you want that doesn’t exist?

#11
AWS has their own crontab syntax, slightly different from regular Cron. But there is no validation tool before you submit something. It just rejects it. I want something like crontab.guru but for cloudwatch syntax. It's such a small usecase but it'd be great.

Re: Ask HN: What small library or tool do you want that doesn’t exist?

#12

I wish VLC, plex, video players in general had the ability to automatically sync subs to audio. ( automatically , not manually) We have the technology; everything we need to do this exists. It's just not done automatically, and when using slightly off-sync subs, you have to fiddle with sub timing for ages until you find the right sync. Even more so when the subtitles have different off-sync issues for the whole movie…

I don't know about 'automatic', but in mpv[1] you have this:

> Ctrl+Shift+Left and Ctrl+Shift+Right

> Adjust subtitle delay so that the next or previous subtitle is displayed now. This is especially useful to sync subtitles to audio.

This works in 9/10 cases. :)

----

[1]https://mpv.io/

Re: Ask HN: What small library or tool do you want that doesn’t exist?

#14
NAME

  swizel - takes csv input, selects columns and arbitrarily selects output order
OPTIONS

  change the field delimiter (default comma)

  handle trimming whitespace per field (or an arbitrary set of chars, e.g. quotes)

  ignore or transform a prefixed one-line header or comment (default #)

  [bonus points] handle numeric fields (e.g. precision or float/int conversion)
OBLIGATORY

  while all of this can already be done with a combination of cut, sed, tr and/or awk, it's a common task when working with columnar data and could be made more intuitive and less error prone. transforming columnar data mostly boils down to clean up and basic sanity checks. good karma on this one.

Re: Ask HN: What small library or tool do you want that doesn’t exist?

#15

I use MS SQL Server a lot at work. I interact with instances via SSMS usually. I'd love a tool that would log to file every query that I execute. Including a customisable comment line with info including when it was run and the server/db it was run against. I'd move to a command line tool, e.g. a sqlcmd variant or shell voodoo, if it could do that.

Try out JetBrains Datagrip (or any IDE that includes it), it’s much more flexible than SSMS. Not sure if this exact feature exists, but they have a plugin interface, maybe you can write one on your own.

They have a log already: https://intellij-support.jetbrains.com/hc/en-us/community/po...

Re: Ask HN: What small library or tool do you want that doesn’t exist?

#17

I wish VLC, plex, video players in general had the ability to automatically sync subs to audio. ( automatically , not manually) We have the technology; everything we need to do this exists. It's just not done automatically, and when using slightly off-sync subs, you have to fiddle with sub timing for ages until you find the right sync. Even more so when the subtitles have different off-sync issues for the whole movie…

I don't know about 'automatic', but in mpv[1] you have this: > Ctrl+Shift+Left and Ctrl+Shift+Right > Adjust subtitle delay so that the next or previous subtitle is displayed now. This is especially useful to sync subtitles to audio. This works in 9/10 cases. :) ---- [1] https://mpv.io/

I think this is what the OP refers to with "fiddle around for ages". I know the problem not with subs, but when audio is off related to the image. And of course the problem is rare enough that I am never "in training", and have to find a remarkable spot first (e.g. door slam shut or a suitable spot in dialogue), then think about going backwards or forwards, guess the amount, etc. etc. :)

Re: Ask HN: What small library or tool do you want that doesn’t exist?

#19
post #11

AWS has their own crontab syntax, slightly different from regular Cron. But there is no validation tool before you submit something. It just rejects it. I want something like crontab.guru but for cloudwatch syntax. It's such a small usecase but it'd be great.

Is it this one? https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/S...

At a quick glance, the syntax looks similar to the one used by Quartz Scheduler, so you can almost use this: https://freeformatter.com/cron-expression-generator-quartz.h...

I say "almost" because Quartz Scheduler expressions have one additional field: seconds. And there are more than likely differences in how nontrivial expressions and corner cases are handled by different tools.

Re: Ask HN: What small library or tool do you want that doesn’t exist?

#20
"Geometry as a service". An API endpoint that takes a compact description of various 3d shapes and returns a GLTF file. I'd start by maybe wrapping the various tools from https://www.antiprism.com/ but there's scope to create a more friendly set of tools for generating generally useful simple meshes.
Post reply on HN