Kotlin SQL

Open-source Kotlin projects categorized as SQL
Edit details
Topics: Kotlin Database ORM Java JSON
Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured

Top 13 Kotlin SQL Projects

  • Exposed

    Kotlin SQL Framework

    • Project mention: Drizzle is just as unready for prime-time as Prisma, what else is there? | /r/reactjs | 2023-12-06

    So is it like Exposed for Kotlin which is a typesafe Kotlin DSL for building sql queries? I’ve been looking for something like this in typescript! https://github.com/JetBrains/Exposed

  • SQLDelight

    SQLDelight - Generates typesafe Kotlin APIs from SQL

    • Project mention: querky – autogenerate Python functions and types for your SQL queries | news.ycombinator.com | 2023-12-15

    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).

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • Ktorm

    A lightweight ORM framework for Kotlin with strong-typed SQL DSL and sequence APIs.

  • jasync-sql

    Java & Kotlin Async DataBase Driver for MySQL and PostgreSQL written in Kotlin

    • Project mention: Java virtual threads caused a deadlock in TPC-C for PostgreSQL | news.ycombinator.com | 2024-01-15

    Was curious what it is "jasync". And man it hurts me to see documentation like this (when compared to classic javadocs)

    https://github.com/jasync-sql/jasync-sql/wiki/API-Overview

    From project WIKI (https://github.com/jasync-sql/jasync-sql/wiki)

  • partiql-lang-kotlin

    PartiQL libraries and tools in Kotlin.

    • Project mention: Amazon Ion Specification | news.ycombinator.com | 2023-09-13

    Ion is heavily used on the retail side of Amazon, but it's only recently started to appear in AWS products.

    AWS is starting support PartiQL (https://partiql.org/) queries in some places and PartiQL uses Ion's type system internally.

  • krush

    Idiomatic persistence layer for Kotlin

  • zeko-sql-builder

    Zeko SQL Builder is a high-performance lightweight SQL query library written for Kotlin language

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo

  • RedditLemmyImporter

    🔥 Anti-Reddit Aktion 🔥

    • Project mention: META: we need a complete dump of https://old.reddit.com/r/CollapseScience/ including the Wiki contents preferably -- please discuss how we can achieve that as comments under that post. Thanks. | /r/CollapseScience | 2023-06-27

    For https://github.com/rileynull/RedditLemmyImporter it needs a Lemmy instance, and an API key for which https://support.reddithelp.com/hc/en-us/articles/16160319875092-Reddit-Data-API-Wiki

  • kimmer

    1. Immer. 2. SQL DSL

  • Sift

    Sift is a basic, Relational Algebra based query engine built on top of Apache Arrow. It draws inspiration from Andy Grove's KQuery. (by RCHowell)

  • ExposedPowerUtils

    ✨ Nifty Utilities and PostgreSQL Extensions for Exposed

    • Project mention: The one where we find a bug storing Instants in PostgreSQL | /r/Kotlin | 2023-05-13

    Shameless plug: https://github.com/PerfectDreams/ExposedPowerUtils

  • Life-Dots

    Record and analyze your life in 8 dimensions: time, event, location, notes, and photos

  • hibernate-minimal-logger

    Library to enable minimal statistical recording of database queries

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Kotlin SQL related posts

  • querky – autogenerate Python functions and types for your SQL queries

    2 projects | news.ycombinator.com | 15 Dec 2023

  • Amazon Ion Specification

    4 projects | news.ycombinator.com | 13 Sep 2023

  • Database Testing with Testcontainers and Kotlin Exposed ORM

    3 projects | dev.to | 29 Jun 2023

  • I'm creating a REST API using KTOR. What's the best ORM to go with KTOR ?

    2 projects | /r/Kotlin | 28 May 2023

  • speed of a left join with millions of rows

    1 project | /r/SQL | 27 May 2023

  • Return a nested list of child table using Kotlin Exposed Dao

    1 project | /r/Kotlin | 22 May 2023

  • Replicating Jetbrains Exposed Star Wars Example in IntelliJ Scratch file

    1 project | /r/IntelliJIDEA | 21 May 2023
  • A note from our sponsor - SaaSHub
    www.saashub.com | 10 May 2024
    SaaSHub helps you find the best software and product alternatives Learn more →

Index

What are some of the best open-source SQL projects in Kotlin? This list will help you:

Project Stars
1 Exposed 7,921
2 SQLDelight 5,937
3 Ktorm 1,991
4 jasync-sql 1,623
5 partiql-lang-kotlin 532
6 krush 250
7 zeko-sql-builder 98
8 RedditLemmyImporter 70
9 kimmer 38
10 Sift 20
11 ExposedPowerUtils 18
12 Life-Dots 16
13 hibernate-minimal-logger 1

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com