Flutter: sqlite (sqflite) | CRUD Operations | Tutorial

preview_player
Показать описание


⭐⭐⭐ SUPPORT ME ⭐⭐⭐

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

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

Рекомендации по теме
Комментарии
Автор

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

schemeta
Автор

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

shawntv
Автор

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

SomebodyOutThre
Автор

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

shrn
Автор

-- 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.

RobertBrunhage
Автор

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

AliAhmad-nnmr
Автор

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!!!!

aislanarislou
Автор

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

christianruge
Автор

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

rajaboy
Автор

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

MortezaAminiKh
Автор

how i can implement relations in many tables schema

Tokando
Автор

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

hamzaimran
Автор

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?

BVideos
Автор

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!

thanusan
Автор

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

furkanvatandas
Автор

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.

jytjfgjfgj
Автор

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

mzkkryv
Автор

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 😀♥️.

snehlatarathore
Автор

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.

AlekseyGureiev
Автор

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):

mrdgrtKawHmuNewsApp
visit shbcf.ru