FunSQL.jl
liquibase
| FunSQL.jl | liquibase | |
|---|---|---|
| 4 | 54 | |
| 139 | 4,427 | |
| 2.9% | 1.8% | |
| 8.0 | 9.9 | |
| 24 days ago | about 19 hours ago | |
| Julia | Java | |
| GNU General Public License v3.0 or later | 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.
FunSQL.jl
-
PRQL a simple, powerful, pipelined SQL replacement
You might enjoy the FunSQL library; SQL verbs are represented using regular Julia objects and you pipeline them together to build bigger queries. A key difference to other SQL builders is that you assemble a tree of "tabular operations" instead of a SQL syntax tree.
https://github.com/MechanicalRabbit/FunSQL.jl
- FunSQL.jl – Julia library for compositional construction of SQL queries
-
PRQL is a modern language for transforming data — a simpler and more powerful SQL
The developers of HTSQL are working now on FunSQL – https://github.com/MechanicalRabbit/FunSQL.jl
-
SQL: The difference between WHERE and HAVING
There is no HAVING and the you can use any tabular operators in any order. Aggregates are also separated from grouping and can be used in any context after Group is applied.
[0] https://github.com/MechanicalRabbit/FunSQL.jl
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?
TablaM - The practical relational programing language for data-oriented applications
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
DifferentialEquations.jl - Multi-language suite for high-performance solvers of differential equations and scientific machine learning (SciML) components. Ordinary differential equations (ODEs), stochastic differential equations (SDEs), delay differential equations (DDEs), differential-algebraic equations (DAEs), and more in Julia.
schemachange - A Database Change Management tool for Snowflake
tresql - Shorthand SQL/JDBC wrapper language, providing nested results as JSON and more
FluentMigrator - Fluent migrations framework for .NET
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
dolt - Dolt – Git for Data
Pluto.jl - 🎈 Simple reactive notebooks for Julia
bytebase - The GitHub/GitLab for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.
SQLToy - Learn SQL by creating a SQL database in JavaScript
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.