Topics

Drizzle Team•7mo ago

error with ILIKE on libsql

I'm trying to use ILIKE clause on libsql and I receive a error. Repository to reproduce the error: https://github.com/emersonlaurentino/libsql-ilike-error

GitHub

GitHub - emersonlaurentino/libsql-ilike-error

Contribute to emersonlaurentino/libsql-ilike-error development by creating an account on GitHub.

2 Replies

Angelelz•7mo ago

SQLite doesn't have an ilike function, that is basically only available in postgres. See here: https://www.sqlite.org/lang_expr.html#operators_and_parse_affecting_attributes You might want to take a look at collation and/or the lower SQL function if you want similar functionality

Emerson•7mo ago

U're right, I'm noob with sqlite ecosystem, thanks for that.

Drizzle Team Join

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

7.6KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Dynamic query buildingI'm trying to replicate the documentation and create a `withPagination` function using query buildin Another SSL error on importI have an existing database and I wanted to try drizzle on it. Database is from a lesser known provi Confusing error with neonHi all! Just setup a project with drizzle (via create-t3-app) but I get this odd, vague error when I Generate Random UUID SqliteHey i was wondering how i would create a unique ID that contains a random string of characters for a Logging query timeIs it possible to log query time? I see that the current logger implementation sends the sql and the [How To?] Generate uuids properly on cloudflare d1 sqlite...I am running an app with Drizzle, TRPC, and Cloudflare D1 sqlite database: My initial project datab Dropping primary keys every timeso latest drizzle-kit fixed a bunch of issues with dropping indexes and preserving pk order but it'need help abstracting a functionThis may be an easy answer but how can I implement the following type? ```typescript export const