sqlcheck
usql
sqlcheck | usql | |
---|---|---|
2 | 21 | |
2,382 | 8,634 | |
- | 0.9% | |
6.0 | 9.2 | |
3 months ago | 4 days ago | |
C++ | Go | |
Apache License 2.0 | MIT License |
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.
sqlcheck
-
T-SQL Best practices analyzer
SQL Check is another open source tool (and multi-platform) which looks for common anti-patterns in TSQL code.
-
What's been your favorite class so far, and why?
8903 is right now - I found a professor working in an area directly pertinent to my professional/industry focus, then reached out to introduce myself and asked if they had bandwidth to take me in to work on one of their projects for 8903 credit. Currently iterating on the SQLCheck project (http://ada-00.cc.gatech.edu/sqlcheck) into IDE extensions and working on the original local version (https://github.com/jarulraj/sqlcheck) to bridge the gaps.
usql
- xo/usql: Universal command-line interface for SQL databases
- Usql – Universal command-line interface for SQL databases
-
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
-
usql 0.11.0
There's a new release of usql that adds even more autocomplete and fixes a bunch of issues: https://github.com/xo/usql/releases/tag/v0.11.0
- 5 Useful Database Command Line Tools
- usql
-
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
[2] https://github.com/httpie/httpie
[3] https://github.com/xo/usql
- usql v0.9.4
What are some alternatives?
stonedb - StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave. (https://stonedb.io)
go-sitemap-generator - go-sitemap-generator is the easiest way to generate Sitemaps in Go
pgadmin3 - PgAdmin3 с поддержкой PostgreSQL 16
hystrix-go - Netflix's Hystrix latency and fault tolerance library, for Go
sqlsmith - A random SQL query generator
boilr - :zap: boilerplate template manager that generates files or directories from template repositories
bdqm-vip
Task - A task runner / simpler Make alternative written in Go
Sequelize - Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
ngrok - Unified ingress for developers
soci - Official repository of the SOCI - The C++ Database Access Library
fzf - :cherry_blossom: A command-line fuzzy finder