prql-query
efcore.pg
Our great sponsors
| prql-query | efcore.pg | |
|---|---|---|
| 3 | 5 | |
| 115 | 1,456 | |
| - | 1.9% | |
| 10.0 | 8.7 | |
| 7 months ago | 17 days ago | |
| Rust | C# | |
| Apache License 2.0 | PostgreSQL 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.
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.
efcore.pg
-
Relational is more than SQL
LINQ in EntityFramework (EF) supports querying JSON columns as objects [1].
unnest support is on the roadmap for EF core for PG [2], but already supported for Couchbase [3].
[1] https://learn.microsoft.com/en-ca/ef/core/what-is-new/ef-cor...
[2] https://github.com/npgsql/efcore.pg/issues/1525
[3] https://github.com/couchbaselabs/Linq2Couchbase/blob/master/...
-
Table partitioning in Postgres from Migration
Sure. I readed https://event-driven.io/en/postgres_superpowers/ and i was curious about implementing partitioning in pg so i searched but i found there are not much results, except this open issue https://github.com/npgsql/efcore.pg/issues/1035. Also there is a pull request from April 2021 to handle this but it fail some tests https://github.com/npgsql/efcore.pg/pull/1789.
-
Poll results, repository pattern over Entity Framework?
Place I joined is using InMemoryProvider for tests. I tried upgrading to .net 6 and the .net 6 npgsql driver. Certain things bit us like no more support for EF.Functions.Like.
-
Are all popular APIs moving to Cursor based pagination?
EF core with PostgreSQL now supports it
https://github.com/npgsql/efcore.pg/pull/2350
- Announcing Entity Framework Core 6.0 Preview 4: Performance Edition
What are some alternatives?
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
EFCore.BulkExtensions - Entity Framework EF Core efcore Bulk Batch Extensions with BulkCopy in .Net for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, MySQL, SQLite
cargo-semver-checks - Scan your Rust crate for semver violations.
Marten - .NET Transactional Document DB and Event Store on PostgreSQL
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
pdd-demo - PostgreSQL Driven Development Demo Web Application With PgRoutiner, .NET and Svelte
ddl-diff - Generates SQL migrations by parsing and diffing DDL
EntityFramework-Reverse-POCO-Code-First-Generator - EntityFramework Reverse POCO Code First Generator - Beautifully generated code that is fully customisable. This generator creates code as if you reverse engineered a database and lovingly created the code by hand. It is free to academics (you need a .edu or a .ac email address), not free for commercial use. Obtain your licence from
FunSQL.jl - Julia library for compositional construction of SQL queries
EntityFramework.Docs - Documentation for Entity Framework Core and Entity Framework 6