Flutter: sqlite (sqflite) | CRUD Operations | Tutorial

⭐⭐⭐ SUPPORT ME ⭐⭐⭐

⭐⭐⭐ CONNECT WITH ME ON SOCIAL MEDIA ⭐⭐⭐

⭐⭐⭐ SETUP ⭐⭐⭐
⌨️ Keyboard: Ducky Shine 3 (brown switches)

[schemeta]

You are going way too fast. Not explaining the code line by line just pasting it from wherever...

[shawntv]

Thanks for bringing me into the sqflite. Keep on making more awesome videos.

[SomebodyOutThre]

Just a note, that's not how you make a tutorial, you can't just read your code and people will understand, you must first talk generally and talk about what package we need, a brief overview about sqflite, how does it handle data ... then talk about the structure of your code, what classes you will use and so on, you are just zooming on a what you are writing and reading it out loud and thinking it's a tutorial, yeah maybe some people will find it helpful I'm just saying for your future videos

[shrn]

This is actually good. Keep up the good work <3

[RobertBrunhage]

-- IMPORTANT --
At 10:23 make sure to increment the returned count by 1 so that you get the id value for the next entry. I forgot to do this and will update the repo!

I will also update the repo regarding parameterized query to avoid SQL injections. The old code will be commented out to show example with arguments.

[AliAhmad-nnmr]

im new in flutter i want to implement 10 to 15 classes with sqlite how to integrate it with foreign_key primary_key
any suggestions

[aislanarislou]

Hey Robert, nice video, many thanks for bring up something different than Firestore + Flutter!
Now my question: I have a Phoenix server with Postgres database with some tables and data. How can I implement synchronization between my server and my flutter app, so that I can have offline capabilities when my app is offline??

Thanks again for the straight forward lesson!!!!

[christianruge]

Thanks for å really helful tutorial! But I get this error: "Error: Type 'SqfLiteCrud' not found.
class _SqfLiteCrudState extends State<SqfLiteCrud> " . Is there a missing "class SqfLiteCrud" in the tutorial? Or how do I get around this one? I'm really thankful for your help!! Kind regards, Christian

[rajaboy]

Can you please explain why did you define db variable outside the class and not inside the DatabaseCreator class?

[MortezaAminiKh]

How to fixed error "Warning database has been locked for Make sure you always use the transaction object for database operations during a transaction" ?

[Tokando]

how i can implement relations in many tables schema

[hamzaimran]

Love the tut.
So you cut and then undo the cut to create this magically appearing effect?

[BVideos]

hey Robert, awesome tutorial! Is it possible to have multiple tables inside the database? Is it just a matter of creating a new createTable function and calling it inside the onCreate function?

[thanusan]

Hey! Thanks for the video - I found it very helpful. Also find it great that you are taking on feedback so constructively. Noob question here: I realised sqlite is stored on disk rather than requiring a server. Where exactly in the project is it stored? I can't find it anywhere in the project - or am I misunderstanding this? Would appreciate any input!

[furkanvatandas]

Your videos are very useful but I have too many tables. Which orm should I use or what I can do?

[jytjfgjfgj]

Hello Robert,
I love your videos man, please keep them coming. I feel like I'm lacking knowledge on Dart side to achieve what I want to do in flutter. It'd be great if you can make Dart videos especially focus on the fancy stuff like futures, streams, generics etc.

[mzkkryv]

Hi Robert,
what does that mean [List<map<String, can u explain it please
Thanx :)

[snehlatarathore]

Hey! Thanks for the video above helped out a lot .I have a question for you!! I have a project where i have to provide a create profile for the user and i have to also show him others who have created their own profile how can i implement such using firebase and flutter .Pls reply i have to complete my project in a month and i am stuck in such problems. Thank you for your videos 😀♥️.

[AlekseyGureiev]

Robert, I have a suspicion, that you are doing it wrong in addTodo method when pacing unescaped values right into the INSERT statement. What happens if the user enters double quotes into the name/info fields (which is perfectly valid) or uses SQL-injection? There's database.insert method that accepts the map for insertion. The same applies to the updates.

[mrdgrtKawHmuNewsApp]

Error when add new keywords


LOG:

Performing hot restart...
Syncing files to device Android SDK built for x86...
I/flutter ( 7974): 1
Restarted application in 2, 177ms.
I/flutter ( 7974): 1
E/SQLiteLog( 7974): (1) near ")": syntax error
E/flutter ( 7974): Unhandled Exception: DatabaseException(near ")": syntax error (code 1 SQLITE_ERROR):, while compiling: INSERT INTO todo
E/flutter ( 7974): (
E/flutter ( 7974): id,
E/flutter ( 7974): name,
E/flutter ( 7974): info,
E/flutter ( 7974): isDeleted,
E/flutter ( 7974): )
E/flutter ( 7974): VALUES (?, ?, ?, ?)) sql 'INSERT INTO todo
E/flutter ( 7974): (
E/flutter ( 7974): id,
E/flutter ( 7974): name,
E/flutter ( 7974): info,
E/flutter ( 7974): isDeleted,
E/flutter ( 7974): )
E/flutter ( 7974): VALUES (?, ?, ?, ?)' args [0, wwww, Leave a comment 🤓, 0]}
E/flutter ( 7974): #0 wrapDatabaseException
E/flutter ( 7974): <asynchronous suspension>
E/flutter ( 7974): #1
E/flutter ( 7974): #2
E/flutter ( 7974): #3 closure>
E/flutter ( 7974): #4 closure>
E/flutter ( 7974): #5 BasicLock.synchronized
E/flutter ( 7974): <asynchronous suspension>
E/flutter ( 7974): #6
E/flutter ( 7974): <asynchronous suspension>
E/flutter ( 7974): #7
E/flutter ( 7974): #8
E/flutter ( 7974): #9
E/flutter ( 7974): #10 RepositoryServiceTodo.addTodo
E/flutter ( 7974): <asynchronous suspension>
E/flutter ( 7974): #11 _SqfLiteCrudState.createTodo
E/flutter ( 7974): <asynchronous suspension>
E/flutter ( 7974): #12 _InkResponseState._handleTap
E/flutter ( 7974): #13 closure>
E/flutter ( 7974): #14
E/flutter ( 7974): #15 TapGestureRecognizer._checkUp
E/flutter ( 7974): #16
E/flutter ( 7974): #17 GestureArenaManager.sweep
E/flutter ( 7974): #18 GestureBinding.handleEvent
E/flutter ( 7974): #19 GestureBinding.dispatchEvent
E/flutter ( 7974): #20
E/flutter ( 7974): #21
E/flutter ( 7974): #22
E/flutter ( 7974): #23 _rootRunUnary
E/flutter ( 7974): #24 _CustomZone.runUnary
E/flutter ( 7974): #25 _CustomZone.runUnaryGuarded (dart:async/zone.dart:931:7)
E/flutter ( 7974): #26 _invoke1 (dart:ui/hooks.dart:263:10)
E/flutter ( 7974): #27 _dispatchPointerDataPacket (dart:ui/hooks.dart:172:5)
E/flutter ( 7974):