csharplang
SQLDelight
Our great sponsors
csharplang | SQLDelight | |
---|---|---|
262 | 32 | |
10,779 | 5,858 | |
1.1% | 1.7% | |
9.6 | 9.6 | |
3 days ago | about 15 hours ago | |
C# | Kotlin | |
- | 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.
csharplang
- Discriminated Unions: Essa feature faz falta no CSharp
-
DevDocs
Certain parts of Microsoft Learn are permissive, for example the .NET BCL documentation is Creative Commons Attribution: https://github.com/dotnet/dotnet-api-docs as is ASP.NET Core: https://github.com/dotnet/AspNetCore.Docs (a good hint if documentation is permissively licensed and on GitHub is if there's an edit button at the top.)
The C# language specification is unfortunately a bit fuzzier: https://github.com/dotnet/csharplang/discussions/4855
The updated unified C# language specification is CC, but it's still catching up to modern C#: https://github.com/dotnet/csharpstandard
-
The golden age of Kotlin and its uncertain future
No OP, but for example you still see the C# folks still struggling to add discriminated unions to the language because of complex interactions due to its too many features[1]. Virtual threads are easier to use than async/await is another example.
-
.NET 8 – .NET Blog
Hi there. I'm the language designer who created the 'Collection Expression' design/specification: https://github.com/dotnet/csharplang/issues/5354
You can see the entire history of the proposal there. To answer you specific question, we went with `..` because that's what the language already uses for the complimentary 'pattern matching deconstruction' form for collection patterns.
In other words, you can already say this today:
if (x is [var start, .. var middle, .. var end]) { ... }
-
What's new in C# 12: overview
Great improvements.
There is PolySharp project that enables you to use most of C#11 features in legacy .NET Framework: https://github.com/Sergio0694/PolySharp - Seems that C#12 features are planned to be implemented: https://github.com/Sergio0694/PolySharp/issues/78
I'm using PolySharp where I'm stuck with .NET Framework 4.6 and I don't have any issues.
Hope one day I'd see concise syntax for catch and/or try expressions: https://github.com/dotnet/csharplang/discussions/2734 - but there is a lot of resistance.
You must specify concrete type.
There was a plan to have "natural type" so "var list = [1,2,3]" would be of type "List" but it was postponed to C# 13 (https://github.com/dotnet/csharplang/issues/5354#issuecommen...)
-
Robust Design through Value Objects in C#
While C# currently lacks direct support for this kind of functionality, there's a glimmer of hope with an active proposal under discussion that aims to bring this feature to the language. This potential addition promises a future where C# can natively offer similar robust type narrowing.
-
The combined power of F# and C#
Given few people anticipated ValueTuple and C# adding a more direct tuple syntax, I feel like it is only a matter of time before C# adds discriminated unions.
(There are multiple proposals tracking the idea. This seems the most comprehensive and "central": https://github.com/dotnet/csharplang/issues/7016)
-
Interceptors (new C# metaprogramming feature) to fuel DapperAOT development
https://github.com/dotnet/csharplang/issues/7009
[Proposal]: Interceptors #7009
> An interceptor is a method which can declaratively substitute a call to itself instead of a call to an interceptable method at compile time. This substitution occurs by having the interceptor declare the source locations of the calls that it intercepts. This provides a limited facility to change the semantics of existing code by adding new code to a compilation (e.g. in a source generator).
- How Much Memory Do You Need to Run 1M Concurrent Tasks?
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
-
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
-
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).
-
"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
SqlDelight is an equivalent library in the Kotlin/JVM ecosystem that follows the same philosophy (write queries in SQL and generate code from them rather than the opposite approach taken by typical ORMs).
What are some alternatives?
Exposed - Kotlin SQL Framework
Realm Asset Helper - A small library to help with Realm.IO integration in Android apps
jOOQ - jOOQ is the best way to write SQL in Java
Ktorm - A lightweight ORM framework for Kotlin with strong-typed SQL DSL and sequence APIs.
RoomAsset - A helper library to help using Room with existing pre-populated database [DEPRECATED].
Realm - Realm is a mobile database: a replacement for Core Data & SQLite
ObjectBox Java (Kotlin, Android) - Java and Android Database - fast and lightweight without any ORM
MapDB - MapDB provides concurrent Maps, Sets and Queues backed by disk storage or off-heap-memory. It is a fast and easy to use embedded Java database engine.
DBFlow - A blazing fast, powerful, and very simple ORM android database library that writes database code for you.
Nitrite Database - NoSQL embedded document store for Java
GreeDAO - Android Database Performance Benchmarks
kotliquery - A handy Database access library in Kotlin