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

[@zangruver132]

Finally package of the week series we all waited for!

[@fellow7000]

It has been available for years already)

[@alexcom_]

I see what you did there.

[@travisantoniello]

Love the XKCD reference

[@LukePighetti]

What's the reference?

[@travisantoniello]

@@LukePighetti "Bobby Tables" is a reference to this comic: xkcd.com/327/

[@Sourav9063]

Waited for this playlist for eternity

[@alexcom_]

Have you tried async?

[@Sourav9063]

​@@alexcom_ package async??

[@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?

[@blank-vw2sb]

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

[@nt4f04und]

430 already lul

[@vertene8165]

Okay, so one person disliked. They must be a react native developer. XD

[@abhinavakkiraju6213]

yup 690 likes and one dislike

[@franklinlegg7719]

No! Ratio = 453:1!

[@muhammadibrahimkhwaja9969]

2.8 K Likes and 6 Dislikes .. Flutter Rocks :)

[@benmarcus2577]

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

[@RioM8z]

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

[@thesloveniaboy123]

Thank you! It looks great!

[@user-bj2pf8pb7s]

I find Moor package is the best

[@lucasgabrielbritosilveira]

GetX is an awesome package

[@denizgursoy672]

yes, it is

[@muhammadyusoffjamaluddin]

OMG I LOVE YOU GUYS.

[@wagnersantos7818]

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

[@paulclapham4197]

Good old Bobby Tables 😂

[@pacozaaskr14]

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

[@mdxenon4749]

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

[@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?

[@lagos6065]

nice !!

[@ce9916]

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?

[@shrutiramnandansharma7139]

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

[@kslash7564]

is it fast as nosql dbs like isar?

[@mazekaty]

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

[@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

[@FedJimSmith]

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

[@LukePighetti]

Those don't run on the phone typically.

[@Llink4n]

really good one :)

[@MDDanishAnsariDev]

But how to use extension functions with sqflite like power(), floor() etc They are not available by default

[@ashishkhuraishy]

Is it Sequel or SQL?

[@agusavior_channel]

This isn't work on web. I had to use moor.

[@alifarhadali5580]

great 💙💙💙💙💙

[@vajidali9979]

Which video recordings do you use? pls reply sir

[@gmikay]

Hi Flutter devs, what database would you recommend to use and why?

[@andreujuanc]

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

[@silverzero9524]

@@andreujuanc what do u think about Hive

[@brunodluka3337]

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.

[@Area-ym6bn]

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

[@davidpanic]

But does it work on flutter web?

[@saibotblack]

no

[@petermusembi738]

No

[@fullstack_journey]

The web has IndexedDB, but not sure if flutter has reinvented the wheel for that yet

[@sadhlife]

@@fullstack_journey nope not yet

[@shanmichaelreyes6255]

floor and moor all the way!

[@JoabeRamone]

Nice!

[@dstr0h]

Is there also a way to use a MySQL database?

[@uttiya10]

Does this support flutter for macOS?

[@Sheychan]

Is there already stream capability?

[@fantamagier]

Hive is very good too

[@fullstack_journey]

Hive next

[@domontowicz]

How to make a fully encrypted local database in Flutter?

[@ShafiqulIslam-sw6qv]

I am going to learn flutter , will anyone give any suggestions How I will start flutter

[@oianmol]

does it support encryption and blah blah blah ?

[@pranavgupta2900]

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.

[@sadhlife]

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

[@learnnow9598]

How to install this sqlite? I am a beginner that's why

[@shubhamjaiswal9314]

I want to join a on site flutter training Suggest someone in India plz

[@kazemcanaanite7338]

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

[@zxenon_]

This tends to rather be "package of any time"...

[@ViralVideoMalayalam]

second comment, next time, will be first.coding is our addiction

[@laravelpixels6935]

Flutter team videos doesn't use data🤗

[@pandas_python]

cool! =)

[@TrikNgonlen]

out of video stocks?

[@israelhipolito]

Sublime :D

[@sonsm4881]

Package name error in the title. Sqlite > sqflite

[@Keneeno]

Not a typo, it is the package name ;)

[@pugreptiles4601]

Do y'all say 'sikjulait' ?? Why not 'askjulait' ???))

[@justapugontheinternet]

Is there a way to sync the local data to a Microsoft sql database?

[@gilbertgatito6666]

Can't use firebase?

[@UnicGamesReviewsmore]

You can! I think sqflite is mostly for local data

[@jmshrv]

Firebase is meant for storing data on the cloud. This package is for storing data locally.

[@linhhoang-bw6od]

I need realm database

[@ERGataullin]

Package of 2 weeks*

[@gourav7315]

Every one Knows about this plugin, Make something new, ❤️ Flutter ❤️

[@duncangroenewald]

Realm

[@RomanLeBg]

When github.com/isar/isar will be ready it will be something else