usql
boilr
Our great sponsors
usql | boilr | |
---|---|---|
21 | 0 | |
8,537 | 1,683 | |
1.3% | - | |
9.0 | 0.0 | |
12 days ago | about 1 year ago | |
Go | Go | |
MIT License | Apache License 2.0 |
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.
boilr
We haven't tracked posts mentioning boilr yet.
Tracking mentions began in Dec 2020.
What are some alternatives?
Task - A task runner / simpler Make alternative written in Go
mergo - Mergo: merging Go structs and maps since 2013
minify - Go minifiers for web formats
go-torch
go-sitemap-generator - go-sitemap-generator is the easiest way to generate Sitemaps in Go
ctop - Top-like interface for container metrics
fastlz - Wrap over FastLz for GoLang
hystrix-go - Netflix's Hystrix latency and fault tolerance library, for Go
hub - A command-line tool that makes git easier to use with GitHub.
wuzz - Interactive cli tool for HTTP inspection
ngrok - Introspected tunnels to localhost