Comments (7)
No problem - the fact that the custom type has to be specified twice here not intuitive at all, I consider this to be a flaw in drift. It's just not easy to fix...
from drift.
I think the postgres package only supports some array types, but we should definitely have support for those in drift_postgres
.
Or is there a dark magic way with custom queries?
You can use custom SQL types as a workaround until we have official support for them. That's not even dark magic, an official API in package:drift_postgres
will be built with the same thing :)
from drift.
I've added them to drift_postgres
in c621ef9.
from drift.
Sweet, thanks :D
You can use custom SQL types as a workaround
Oopsies, totally forgot about this functionality, my bad
from drift.
Hmm, it seems I can get it working with default values
class User extends Table {
Column<List<int>> get example => customType(PgTypes.bigIntArray).withDefault(const Constant([]))();
}
Throws :
Invalid argument (dart): Must be null, bool, String, int, DateTime, Uint8List or double: _ImmutableList len:0
from drift.
Ah right, I think you'd have that problem with all custom types - at the moment we're unfortunately unable to infer the type to apply in that context.
Does it work if you explicitly apply the type on the constant, e.g Constant([], PgTypes.bigIntArray)
?
from drift.
It indeed does, thank you very much.
Sorry, I should really open my eyes somehow, the solution was right in front of me..
from drift.
Related Issues (20)
- feat: Get references from manager HOT 4
- Package import mismatch in generated file HOT 2
- [drift_postgres] Postgres implicit type casts not working in raw queries HOT 1
- Manager: Support tables with custom row classes HOT 1
- Share db with host Android app embedded flutter readonly/read write problems HOT 5
- disk I/O error
- `enableMigrations` param for web implementation. HOT 1
- feat: Common Root Manager Operations should work with id
- Error while trying to run in flutter web HOT 1
- Upsert against db object behaves differently to upsert against batch HOT 2
- Allow QueryInterceptor to ignore/exclude specified tables HOT 1
- Converting database keys in toJson from camelCase to snake_case HOT 1
- LazyDatabase is imposible to execute queries when reopen HOT 1
- flutter web unable to build HOT 1
- No `SqliteException` thrown if when fetching data from non existent column in test mode HOT 4
- Can't compile to wasm HOT 1
- [web] TypeError: Failed to execute 'compile' on 'WebAssembly': Incorrect response MIME type. Expected 'application/wasm' HOT 1
- SqliteException(1): while preparing a statement, unrecognized token: "@" HOT 3
- Database can no longer be mocked with new manager API HOT 10
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from drift.