sqflite (Flutter Package of the Week)

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.

[zangruver]

Finally package of the week series we all waited for!

[benmarcus]

Thank you so much Flutter team!!!
I think I even asked for this video so Double thankYou; -)

[wagnersantos]

Awesome series.... i'm excited for more videos suggesting good packages... I would love it if you put third party packages in this series.

[MDDanishAnsariDev]

But how to use extension functions with sqflite like power(), floor() etc

They are not available by default

[anudeepananth]

#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?

[mdxenon]

Hi, is there a full tutorial, front + connect to db + req?, thanks for attention

[RioMz]

It is really great library. Unfortunately it is not able use it in flutter for web.

[domontowicz]

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?

[ce]

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?

[mazekaty]

How long can a dart and flutter count on a fullstack?

[pacozaaskr]

Why do we need database "in" mobile app? Isn't it more sustainable to use backend to access database?

[vajidali]

Which video recordings do you use? pls reply sir

[bashircodes]

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

[dstrh]

Is there also a way to use a MySQL database?

[Area-ymbn]

Why google sheet created with my flutter App using the api is not showing in google drive? Any help

[blank-vwsb]

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

[shrutiramnandansharma]

I used it and that is really great but for now I need it for desktop application.

[domontowicz]

How to make a fully encrypted local database in Flutter?

[FedJimSmith]

will there be a future support for graph databases like Neo4j or Arango?

[oianmol]

does it support encryption and blah blah blah ?