sqflite (Flutter Package of the Week)
HTML-код
- Опубликовано: 30 июл 2024
- Sometimes, your app needs to save important data on the device. If it's structured data, chances are you want to use a SQL database. SQLite is a SQL database engine that is available on almost any device, including mobile phones. One of the best cross-platform SQLite packages for Flutter is package:sqflite - the topic of this video.
Learn more about sqflite → goo.gle/2LnRwCT
Learn everything about Flutter at → goo.gle/2WAhEN1
Get more tips! → goo.gle/307BX6t
Subscribe! → goo.gle/FlutterYT 
Наука
Finally package of the week series we all waited for!
It has been available for years already)
I see what you did there.
Thank you so much Flutter team!!!
I think I even asked for this video so Double thankYou; -)
Thank you! It looks great!
Waited for this playlist for eternity
Have you tried async?
@@alexcom_ package async??
Love the XKCD reference
What's the reference?
@@LukePighetti "Bobby Tables" is a reference to this comic: xkcd.com/327/
Awesome series.... i'm excited for more videos suggesting good packages... I would love it if you put third party packages in this series.
#askFlutter I am a native Android developer considering migrating to Flutter, I have done all the research for the core library alternatives in Flutter. One thing I am particular about is that when When working with a list of large data. In Android, we can persist this data in an SQLite local DB using the ROOM library. What's even better is that with the RemoteMediator class available in Paging 3 Android library, we can create an infinite scrolling recycler while querying data from the local DB while the network call queries new data and stores it in the DB. So the recycler queries data from the database not from a network call. So this data can be access without internet access.
I know that the sqflite package is Flutter's alternative to ROOM in Android but can we use this database to query a paged list of items to display in the ListViewBuilder and the user scrolls?
But how to use extension functions with sqflite like power(), floor() etc
They are not available by default
OMG I LOVE YOU GUYS.
It is really great library. Unfortunately it is not able use it in flutter for web.
really good one :)
Hi, is there a full tutorial, front + connect to db + req? , thanks for attention
In one place on the page it says that it's only for macOS as far as desktops go, but in another place it says that it's also available for Linux and Windows. Does anyone wanna know what the bottom line is?
How to immediately add items from a ready-made SQLite database to the listView without unnecessary pages of code? Why is there no custom widget that already contains a listview and a database and a search?
Why do we need database "in" mobile app? Isn't it more sustainable to use backend to access database?
Nice!
How long can a dart and flutter count on a fullstack?
Hi, flutter I have question out of this topic I was developing an application so one of the feature of the app is calling phone numbers directly inside app but so far have searched alot about this and i didn't got any answer for this question. This makes me disappointed to flutter all answers I have got are just re-directing to the default phone dailler I want like how jave do when you want call number in your app it asks permission for first time and later call direct without re-directing. Please need help me thanks
nice !!
I used it and that is really great but for now I need it for desktop application.
is it fast as nosql dbs like isar?
Which video recordings do you use? pls reply sir
Is there already stream capability?
great 💙💙💙💙💙
As of now,
300 likes and 0 dislikes.
That's what I want.
Keep the like/dislike ratio as Infinite
Oct 9 EDIT:
☺️ 901 Likes
😅 2 jealous react native devs disliked
430 already lul
Okay, so one person disliked. They must be a react native developer. XD
yup 690 likes and one dislike
No! Ratio = 453:1!
2.8 K Likes and 6 Dislikes .. Flutter Rocks :)
Does this support flutter for macOS?
floor and moor all the way!
Is there also a way to use a MySQL database?
Why google sheet created with my flutter App using the api is not showing in google drive? Any help
will there be a future support for graph databases like Neo4j or Arango?
Those don't run on the phone typically.
Good old Bobby Tables 😂
Hive is very good too
Is it Sequel or SQL?
GetX is an awesome package
yes, it is
Sublime :D
Hive next
cool! =)
How to make a fully encrypted local database in Flutter?
does it support encryption and blah blah blah ?
I want to join a on site flutter training
Suggest someone in India plz
Is there a way to sync the local data to a Microsoft sql database?
How to install this sqlite? I am a beginner that's why
Hi Flutter devs, what database would you recommend to use and why?
Depending on your use case. What are you building?
Firestore is easy to start with, but security is a bit time consuming.
FaunaDB is great.
As for local dB SQLite is a great choice, you can store unstructured data as well
@@andreujuanc what do u think about Hive
If you want to store small things, try Hive, otherwise give a try to Moor. It uses sqflite but it's a way more intuitive.
I find Moor package is the best
Hello. I have a problem please help. I am a student of the Faculty of Iraqi Computer Science and wanted to learn the language of the arrival and create applications on Flutter but after the program was set up and the language on Android Studiio did not accept my phone and tried to resume this problem repeatedly and repeatedly and did not I hope you can help me. And that I could take his phone number to continue with him
How to reduce the size of an app. I am beginner and i made xylophone App which was 100mb in size. Please share the solution.
use smaller images and other assets. don't use the debug build, make a release build. split your apk per abi. if you can, move the assets to some CDN and then download it on the user's device instead of putting them in the apk. a simple xylophone app shouldn't be more than 10mb
This isn't work on web.
I had to use moor.
But does it work on flutter web?
no
No
The web has IndexedDB, but not sure if flutter has reinvented the wheel for that yet
@@fullstack_journey nope not yet
out of video stocks?
This tends to rather be "package of any time"...
I am going to learn flutter , will anyone give any suggestions How I will start flutter
Can't use firebase?
You can!
I think sqflite is mostly for local data
Firebase is meant for storing data on the cloud. This package is for storing data locally.
I need realm database
Flutter team videos doesn't use data🤗
second comment, next time, will be first.coding is our addiction
Package name error in the title. Sqlite > sqflite
Not a typo, it is the package name ;)
Package of 2 weeks*
Do y'all say 'sikjulait' ?? Why not 'askjulait' ???))
Realm
When github.com/isar/isar will be ready it will be something else
Every one Knows about this plugin, Make something new, ❤️ Flutter ❤️