usql
Task
Our great sponsors
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
usql
-
PRQL a simple, powerful, pipelined SQL replacement
Also all languages has an query-builder / ORM so the benefit of something like PRQL is possibly not big enough to merit it as an additional dependency.
My suggestion:
Make PRQL a cli tool that can be used by allowing users to connect to a database in a similar fashion as something like usql (https://github.com/xo/usql),
-
Is there a CLI interface to browse SQL databases?
take a look at: https://github.com/xo/usql
-
New Open source Go projects looking for contributors
https://github.com/xo/usql has some good first issues
- 5 Useful Database Command Line Tools
-
Literate programming is much more than just commenting code
I am not a big fan of the complex literate programming style involving code-generation which this article talks about.
But I recently discovered that Google's zx [1] scripting utility supports executing scripts in markdown documents and I combined it with httpie [2] and usql [3] for a bit of quick and dirty automation testing and api verification code and it worked out pretty well.
[1] https://github.com/google/zx#markdown-scripts
-
Usql 0.9.1 – Now with Autocomplete
There's a new version of usql - the universal command-line client for SQL databases.
After I started contributing to it a while ago, I went through all comments in older posts about it here on hackernews. I think the most requested feature was autocomplete. So I went ahead and implemented it. I surprised myself, how useful it ended up being. This includes completing filenames and even command names which I use on a regular basis and know very well.
Another thing we managed to figure out are static builds for Linux. If you previously had issues with starting usql, seeing errors about libicu, you might want to give this latest version a try.
There's also a basic implementation of the `\copy` command. Combined with the `csvq` driver, it allows loading CSV or JSON files to any supported database. But it doesn't do _any_ type mapping, so you might have to add some casting in the source query.
Other new features include pager support, output to a file or a pipe, `\crosstab` command, and many more.
If that got your attention, give it a spin. Full release notes are available at https://github.com/xo/usql/releases. As always, all feedback and contributions are welcome.
-
Reading database metadata (schema)
A few months ago I started working on adding \d* commands to usql that would allow to list and describe various database objects, like tables, views, indexes, etc. I started looking for existing solutions in Go and stumbled upon this issue: https://github.com/golang/go/issues/7408
-
usql: the universal command-line client for SQL databases
For more, check out the release notes: https://github.com/xo/usql/releases/tag/v0.9.0
If you've not seen usql before, it's a universal command-line client for effectively every SQL database in existence. It pays humble homage to psql, and works similarly. We just pushed v0.9.0, which has an amazing number of new features that aren't found in most database's native command-line clients. Happy to answer any questions.
Task
-
Show HN: Workflow Orchestrator in Golang
So many tools in this space! This one looks a little bit like go-task, but it seems maybe better for production workflows because if timeout support, while go-task seems more aimed to command line work/makefile replacement.
—-
-
Essential Command Line Tools for Developers
Task Task is a task runner / build tool that aims to be simpler and easier to use than, for example, GNU Make. Installation | Documentation | Twitter | Mastodon | Discord
View on GitHub
-
Using Make – writing less Makefile
A similar tool is `task` https://taskfile.dev/ . It is quite capable and also a single executable. I've grown to quite like it.
If you're looking to an alternative, you could take a look at Task:
-
What’s with DevOps engineers using `make` of all things?
check out tasks - a bit of a learning curve but arguably more powerful imo
https://taskfile.dev/ - a mix of build tool and command runner. YAML for the Taskfiles which you might consider either a pro or con. :)
-
Go Development with Hot Reload Using Taskfile
That's when I came across taskfile.dev. Task is an automation tool designed to be more accessible than other options, such as GNU Make.
-
Poetry (Packaging) in motion
Full disclosure, I did not review Conda or Hatch fully. Not that there is anything explicitly wrong with either of them. Conda is too specific to the scientific community for my general taste. Hatch seems to go well with Conda and also uses the PyProject manifest as well. It's nice that it gives you several built in tools, similar to commit hooks, but I tend to like to roll my own via a Taskfile and run them with Poetry.
What are some alternatives?
just - 🤖 Just a command runner
doit - task management & automation tool
goreleaser - Deliver Go binaries as fast and easily as possible
boilr - :zap: boilerplate template manager that generates files or directories from template repositories
JobRunner - Framework for performing work asynchronously, outside of the request flow
taskctl - Concurrent task runner, developer's routine tasks automation toolkit. Simple modern alternative to GNU Make 🧰
spinner - Go (golang) package with 90 configurable terminal spinner/progress indicators.
kazaam - Arbitrary transformations of JSON in Golang
go-sitemap-generator - go-sitemap-generator is the easiest way to generate Sitemaps in Go
hystrix-go - Netflix's Hystrix latency and fault tolerance library, for Go
grequests - A Go "clone" of the great and famous Requests library