prql-query
liquibase
Our great sponsors
prql-query | liquibase | |
---|---|---|
3 | 54 | |
115 | 4,394 | |
- | 2.3% | |
10.0 | 9.9 | |
7 months ago | 4 days ago | |
Rust | Java | |
Apache License 2.0 | 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.
prql-query
-
Relational is more than SQL
Thank you.
The CLI usability was one of the aims behind [prql-query (pq)](https://github.com/prql/prql-query/). sqlite integration was on the roadmap but unfortunately that project has been largely unmaintained by me for the past 6 months. (This is just referring to prql-query and not PRQL which is under very active development.)
I'm working on a new project which will do exactly this (and a lot more!) which I hope to release next week. I'll drop the link here when that's ready.
-
GQL: A SQL like query language for .git files
As an aside, I could also look at including GQL as a backend in pq (https://github.com/prql/prql-query/) which is my project. It's a bit badly maintained the last few months due to my time constraints but I want to do a big upgrade with the imminent PRQL 0.9 release.
-
PRQL a simple, powerful, pipelined SQL replacement
Thanks for the suggestion. I don't think I knew about usql. I completely agree with you and have been working on a cli tool called `prql-query` or `pq` at the command line:
https://github.com/prql/prql-query/
Unfortunately I haven't had much time to spend on it of late but hope to push some updates soon.
liquibase
-
I am looking for a troubled/bad open source codebase
While I respect the work, Liquibase's code base is quite messy... https://github.com/liquibase/liquibase
-
Any free SchemaDiff tools out there? pgAdmin Schema Diff created a script but it fails (order is wrong, etc)
Have you looked at liquibase?
-
dbForge Schema Compare vs Redgate SQL Compare vs ApexSQL Diff
For those in search of a open source solution with commercial support have a look at https://www.liquibase.org/
- How do you manage database structure changes? And deploying code?
-
Better alternatives to schemachange for Snowflake Database Object Deployment
I haven't used it for a number of years but it sounds like something like liquibase (https://www.liquibase.org/) might be what you're looking for.
-
Version control for database used by C# app
Liquibase
- Dumb Question: Initializing a database.
-
How do you handle migrations ?
We use https://github.com/liquibase/liquibase, as most of Dev are used to and comfortable with it.
-
Schema vs non-schema prpgramming
Highly recommend you use either Liquibase or Flyway for schema management, and Testcontainers pg to run a transitive database for your tests.
-
Deploying data across environments
I haven't used this so I'm not sure it does exactly what you're looking for but I had a DBA recommend it to me as a possible tool to start using as we overhaul our pipelines. https://www.liquibase.org/
What are some alternatives?
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
cargo-semver-checks - Scan your Rust crate for semver violations.
schemachange - A Database Change Management tool for Snowflake
data-toolset - Upgrade from avro-tools and parquet-tools jars to a more user-friendly Python package.
FluentMigrator - Fluent migrations framework for .NET
Linq2Couchbase - A Language Integrated Query (LINQ) provider for the Couchbase .NET SDK
dolt - Dolt – Git for Data
ddl-diff - Generates SQL migrations by parsing and diffing DDL
bytebase - The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.
FunSQL.jl - Julia library for compositional construction of SQL queries
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.