Tortuga Chain
SQLDelight
| Tortuga Chain | SQLDelight | |
|---|---|---|
| 11 | 32 | |
| 335 | 5,917 | |
| 0.0% | 1.0% | |
| 6.1 | 9.6 | |
| about 1 month ago | 8 days ago | |
| C# | Kotlin | |
| 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.
Tortuga Chain
- Resistance to use Entityframework !!
-
C# 11 Raw String Literals Explained
I mean, look at this mess: https://github.com/TortugaResearch/Tortuga.Chain/blob/main/Tortuga.Chain/Tortuga.Chain.SqlServer/shared/SqlServer/SqlServerMetadataCache.cs
- Does anyone know how I can return character length limits from a query?
- PostgreSQL 14 Breaks the .NET and Java Drivers for PostgreSQL - New features don't play nice with legacy workarounds
-
What was used before LINQ to SQL
Omg I didn’t realize this was you: https://github.com/TortugaResearch/Chain
-
"ORMs have a special place in my heart, not entirely unlike Brutus and Caesar: a dear friend who betrays you and leaves you to die a slow, painful death." – Taming SQL and ORMs with sqlc
You can see a comparison in the ORM Cookbook. https://tortugaresearch.github.io/DotNet-ORM-Cookbook/ and this (out of date) post https://github.com/TortugaResearch/Chain/wiki/A-Chain-comparison-to-Dapper.
-
Traits for C#
Here is a real example from the ORM that I built this for: https://github.com/TortugaResearch/Chain/blob/Traits/Tortuga.Chain/Tortuga.Chain.Access/Generated/Tortuga.Shipwright/Tortuga.Shipwright.TraitGenerator/Tortuga.Chain.Access.AccessDataSourceBase.cs
- Why most people use Dapper instead of EF Raw Queries?
- Check if a column allows nulls
- EF/Dapper vs Custom-developed ORM
SQLDelight
-
querky – autogenerate Python functions and types for your SQL queries
This seems to be similar to https://github.com/cashapp/sqldelight, and I've always wanted a python equivalent!
In typescript, there are query builders (not talking about ORMs) that can basically do this within the type system, but that would be infeasible in python's type system. This approach (type/code generation is a good alternative, though I like using sqlalchemy / alembic to manage schemas/migrations.
One thing I'm curious about is how it knows the types of columns? I looked quickly at the Readme but didn't see it (probably a parameter somewhere I missed).
- I'm creating a REST API using KTOR. What's the best ORM to go with KTOR ?
-
KMM alternatives to Android Datastore & Room DB?
That functionality has existed for almost exactly a year
-
What were your negative experiences when adopting KMM?
- SQLDelight - great experience overall, the only issue that I found, was when that I made a database migration that worked on Android, but not on iOS (https://github.com/cashapp/sqldelight/issues/3812)
-
Adopting Kotlin Multiplatform Mobile(KMM) on 9GAG App
Database - SQLDelight
-
Android Starter Template (hilt, ktor, coroutines, flow, modules, gradle.kts, version catalog, compose, MVVM, tests, GitHub CI)
room is a great example but like I said our data is kotlin-only so we tend to use libraries like sqlDelight.
-
Announcing new crate - "hugsqlx": turning SQLx queries into Rust functions
This seems similar to https://cashapp.github.io/sqldelight/ for kotlin, I think this approach is pretty neat, good luck with it!
-
ADVICE WANTED - Typescript PostgreSQL without ORM
Sounds like you want what SQLDelite offers, but for TypeScript. SQLDelite is only for Kotlin and SQLite though.
-
Why We're Moving on from Firebase
SQLDelight had neat built in support for this
https://cashapp.github.io/sqldelight/
-
Flyweight: An ORM for SQLite
You would really like sqldelight[1] then. It takes the concept of an ORM and flips it on its head. Instead of mapping function calls to SQL statements, it lets you write SQL statements and then generates classes for you that have methods for those statements.
For instance, you could have a SQL statement like getCardsForFight: select * from fights where cardId = ? and titleFight = ?, and it would generate a class that has a method getCardsForFight(cardId: number, titleFight: number).
[1]: https://github.com/cashapp/sqldelight
What are some alternatives?
Dapper - Dapper - a simple object mapper for .Net [Moved to: https://github.com/DapperLib/Dapper]
Exposed - Kotlin SQL Framework
LINQ to DB - Linq to database provider.
Realm Asset Helper - A small library to help with Realm.IO integration in Android apps
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
Ktorm - A lightweight ORM framework for Kotlin with strong-typed SQL DSL and sequence APIs.
TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
jOOQ - jOOQ is the best way to write SQL in Java
SQLProvider - A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
RoomAsset - A helper library to help using Room with existing pre-populated database [DEPRECATED].
Dapper Extensions - Dapper Extensions is a small library that complements Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your POCOs. For more advanced querying scenarios, Dapper Extensions provides a predicate system. The goal of this library is to keep your POCOs pure by not requiring any attributes or base class inheritance.
Realm - Realm is a mobile database: a replacement for Core Data & SQLite