K
Kysely•4mo ago
oof2win2

transforming database values to JS values (dates in sqlite)

hi. is it possible to transform database values with any driver into any JS value? such as integers to timestamps on specified columns? i want to do this for sqlite and other databases but idk how
1 Reply
oof2win2
oof2win2•4mo ago
i mean when using the official sqlite driver it translates a Date object into a ISO string which seems weird https://kyse.link/#cN4IgpgJglgLg9gJwM4gFyhgTwA5jSKAW20RgAJgAdAOzLIHExqwEBDGSAGhroGUwANmADGMVgCMh3WmQCq2COzASpPMgElqSFmMlhpAXzIAzBHEJlKIANaZtAzFYDcNGmAAeJBOSjUOCY1ZhMDIAEXYJVm0KNVxkOGpUMgAFFiQEgBUVMBcZXBgk1JgsvVyDV2ZPUjJff0DglLTM7JiZKAgkxmY2DggAHmoAV0JxFgA+XLpjKGQYAH1qVkIwJKQYBF8Ac0myASj5xeWk8I4dzaYIFk6LljKKjy8fPxZ6kKKSoVa6duvupX6hiNxjtDisyGsNtRtmo4AB3bpzH5kQGjBA7JC4YRQMBIJK8THYpB3ahuKreMhYXAMG4IMgAXksIEIrCEVjIAB9GcYwMzWSAOYy4DAABYsZykx4UnAhfEiQn0xkQOCbNmcqzCdiqxnCpZrMUgXIS6qUt5NWgM-hCUTZPqpeLUD5gCZG8kmsgAOTAsLt6XNGi0OhtPuaemdlUlbuD1Hkig4CpjSiDZsdYZd5EjYHIFsEIl0QltmZTuQexulHq9RQVmm03iTxWyYZLrrLRQTcYZbeUegL9dDThAnBAAEdBixMPgiJLgOChwIyEZTOZGbZ7I4DTRJ9Vp7KsTj5yYzBYrCaALSQWCIcUk6jCBJrcEEnF4x9IBVWHWEPUIK80W9achmLCr4MqwsKsLAZAQOIagAHT2LmABih4ABRWHEvpWAAlLB8GiAAggIAjIdhMgwbCooIGAqEgHsawLEsYBWJwjJjExyJemESjESRdAwR4IiDBwxH9gYg7QCyub4Egs6wHgg4roI47oCAJr4GImwDiAoL4AADDBABMADsBkgAYBhAA
Want results from more Discord servers?
Add your server
More Posts
How to enable pragmas with SqliteDialectHello, I am using SqliteDialect and want to enable foreign_keys pragma. From [SQLite Docs](https:/Dynamic return type based on provided select arraySo I have this function: ``` async getBillableUsers(select: SelectExpression<DB, 'user_data'>[]) { How to work with json columns?There are so many different sources in the documentation as those made me confused completely. I useDoes the TypeScript performance scale with larger projects?I just started migrating to kysely, love it so far! I was wondering how well the TypeScript performaSQLite__namespace is not a constructorHi Im building a Electron-Vite App and running into the following error: ``` TypeError: SQLite__nameRaw SQL in where clauseI have the following code and I'm getting a type error. This is strange as the raw sql statement worsmallint support (Postgres)Type dataType does not contain smallint? ```TS addColumn<CN extends string>(columnName: CN, dataTypeExamples inner join using OR?Hello, we are having trouble trying to have a inner join using OR, as in `ON a.id = b.id OR a.sub_id