Comments (1)
Thanks for the report.
I'm pretty sure I know where the concurrent modification error is coming from and I'll fix it in the next release. As a workaround, I suggest to either
await
the insertion of the category before inserting the todo entry- start a transaction and execute both queries in there (this is more efficient, as queries that read from categories and todos would only be updated once in that case, whereas they would first react to the updated categories table and then to the updated todos table with the first solution.)
I see that the very primitive use of the bloc pattern in the example is of no help here, I'll have to clean that up a bit as well.
This is only semi-related to the issue, but I see you're creating a stream in each TodoCard
. This could result in some performance problems, as every of these streams will fetch its data again whenever the categories
table changes. For now, my suggestion would be a custom query that uses a join to load the category for each todo entry. I'll hopefully implement an easy api for joins soon, which will make this easier.
from drift.
Related Issues (20)
- Code generation failure HOT 1
- How to listen data in stream, while write it at the same time
- "Null check operator used on a null value" during update.replace call HOT 5
- WSL Ubuntu22 - app that uses drift renders as fully white screen HOT 2
- Mentioning that `drift_db_viewer v2.0.0` is breaking due to changes in `Flutter v3.22+` Material implementation HOT 4
- [macos] Cannot find database file in documents path HOT 2
- Upcoming special SQL NULL handling in drift_postgres HOT 2
- Allow the direct use of WITH CTEs with the IN operator in Drift files HOT 4
- `storeDateTimesAsText` dialect aware HOT 4
- Table code generation with conditional export library HOT 2
- async* does not return updated values HOT 4
- Build error inheriting public base table HOT 1
- Add Support for Richer SQL Queries(Raw Strings) in customSelect HOT 4
- Drift file BigInt Generation HOT 2
- In app migrate v13 issue HOT 1
- my view table have not use group by and order by to sql, with version 2.15.0 HOT 2
- Probably Corrupted DB HOT 4
- BigInt mapping in web with unexpected type HOT 3
- MacOS sqlite-src-3450100 Warnings HOT 2
- Modular code generation for manager
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.