A modern programming language that makes developers happier.

kotlinlang

table.png

delete.png

select.png

insert.png

update.png

Hey everyone :wave:

:rocket: *Introducing KQLite v0.2.1 – Typesafe SQL for Kotlin Multiplatform*

A lightweight *Kotlin Multiplatform DSL* that lets you write *typesafe SQL queries using Kotlin object-style syntax* instead of raw SQL strings.

:globe_with_meridians: Website: <https://kqlite.com/|kqlite.com>

:sparkles: *Why KQLite*?
If you’ve ever struggled with raw SQL strings, unsafe queries, or boilerplate mapping, KQLite is designed to make your database layer cleaner, safer, and more Kotlin-friendly across platforms.


:fire: *Key Highlights*
• ORM-style interaction with tables
• Typesafe Cursor (lazy execution + auto-close on full iteration)
• Typesafe value binding &amp; reading
• Built-in entity binding &amp; mapping
• Cursor as *Flow* → emits on INSERT / UPDATE / DELETE
• Quick &amp; convenient APIs for faster development
• Built-in SQLite functions (Scalar, Aggregate, Math, Date/Time, JSON)
• Familiar SQLite-inspired DSL
• No plugin - No generated code

:earth_africa: *Kotlin Multiplatform Targets*
• Android
• iOS
• JVM
• macOS
• Linux
• tvOS
• watchOS

:package: *Dependency*
```implementation("com.kqlite:kqlite:0.2.1")```

:test_tube: *Samples &amp; Examples*
• KQLite Contacts: <https://github.com/AzimAnsari/KQLiteContacts|github.com/AzimAnsari/KQLiteContacts>
• PeopleInSpace Sample: <https://github.com/AzimAnsari/PeopleInSpaceKQLite|github.com/AzimAnsari/PeopleInSpaceKQLite>
• Droidcon Sample: <https://github.com/AzimAnsari/DroidconKQLite|github.com/AzimAnsari/DroidconKQLite>
• D-KMP Sample: <https://github.com/AzimAnsari/D-KMP-sample-KQLite|github.com/AzimAnsari/D-KMP-sample-KQLite>



:page_facing_up: *License*
KQLite is *not open source*.
Proprietary License: <https://github.com/AzimAnsari/KQLiteDocs/blob/main/LICENSE|github.com/AzimAnsari/KQLiteDocs/blob/…/LICENSE>


:bulb: This has been months of hard work, focused on making SQL in KMP more intuitive, reactive, and typesafe.
Would love your feedback, thoughts, also open to API changes :raised_hands:
Feel free to try it out and share what you think!

Nice, can you compare it with Exposed? <https://www.jetbrains.com/help/exposed/home.html|jetbrains.com/help/exposed/home.html>

It's not open source, and the license explicitly forbids commercial use. I think these factors will make it difficult for your library to attract users.

Yes <@U0B8MSP9B> I know Exposed is a big thing with its own complex DSL syntax.
I think Exposed has its own learning curve.
• KQLite should be known for its simplicity. 
• It does not try to own anything. 
• DSL syntax closely matches with existing SQL
• Works with any driver that can open androidx SQLiteConnection

You mean that binary size of library is smaller?

I will look myself to see the difference for the conclusion

<@U2VU05RC4> Its for trial run and open to feedback. We are working on to make it free for use and close sourced.

There are also well established SqlDelight and Room

Thanks Eugen. Do check it out and let us know.
<http://kqlite.com|kqlite.com>
Also check out samples

Yes this competes with SQLDelight and Room. But without any extra plugin and auto generated code.

It’s more of a language than a database.