Data Persistence Using SQLite

4 minutes
Share the link to this page
You need to have access to the item to view this lesson.
One-time Fee
List Price:  $139.99
You save:  $40
List Price:  €129.17
You save:  €36.90
List Price:  £110.02
You save:  £31.43
List Price:  CA$191.15
You save:  CA$54.61
List Price:  A$210.08
You save:  A$60.02
List Price:  S$188.77
You save:  S$53.93
List Price:  HK$1,092.75
You save:  HK$312.23
CHF 91.40
List Price:  CHF 127.97
You save:  CHF 36.56
NOK kr1,068.48
List Price:  NOK kr1,495.92
You save:  NOK kr427.43
DKK kr688.44
List Price:  DKK kr963.84
You save:  DKK kr275.40
List Price:  NZ$228.70
You save:  NZ$65.35
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  ৳16,410.04
You save:  ৳4,688.92
List Price:  ₹11,657.31
You save:  ₹3,330.90
List Price:  RM656.90
You save:  RM187.70
List Price:  ₦201,305.62
You save:  ₦57,520
List Price:  ₨38,987.91
You save:  ₨11,140.19
List Price:  ฿5,087.62
You save:  ฿1,453.71
List Price:  ₺4,505.29
You save:  ₺1,287.32
List Price:  B$717.15
You save:  B$204.91
List Price:  R2,545.11
You save:  R727.22
List Price:  Лв252.39
You save:  Лв72.11
List Price:  ₩191,270.87
You save:  ₩54,652.72
List Price:  ₪514.18
You save:  ₪146.92
List Price:  ₱8,124.45
You save:  ₱2,321.43
List Price:  ¥21,898.07
You save:  ¥6,257.04
List Price:  MX$2,326.14
You save:  MX$664.66
List Price:  QR510.64
You save:  QR145.90
List Price:  P1,887.68
You save:  P539.37
List Price:  KSh18,478.68
You save:  KSh5,280
List Price:  E£6,550.13
You save:  E£1,871.60
List Price:  ብር8,046.40
You save:  ብር2,299.13
List Price:  Kz119,061.49
You save:  Kz34,020
List Price:  CLP$124,379.71
You save:  CLP$35,539.60
List Price:  CN¥993.01
You save:  CN¥283.74
List Price:  RD$8,224.84
You save:  RD$2,350.12
List Price:  DA18,836.81
You save:  DA5,382.33
List Price:  FJ$316.51
You save:  FJ$90.44
List Price:  Q1,087.38
You save:  Q310.70
List Price:  GY$29,320.35
You save:  GY$8,377.84
ISK kr13,848.61
List Price:  ISK kr19,388.61
You save:  ISK kr5,540
List Price:  DH1,389.92
You save:  DH397.15
List Price:  L2,473.55
You save:  L706.77
List Price:  ден7,958.15
You save:  ден2,273.92
List Price:  MOP$1,125.85
You save:  MOP$321.69
List Price:  N$2,539.14
You save:  N$725.52
List Price:  C$5,155.83
You save:  C$1,473.20
List Price:  रु18,663.10
You save:  रु5,332.69
List Price:  S/524.70
You save:  S/149.92
List Price:  K544.20
You save:  K155.49
List Price:  SAR525.03
You save:  SAR150.02
List Price:  ZK3,617.21
You save:  ZK1,033.56
List Price:  L642.65
You save:  L183.62
List Price:  Kč3,193.84
You save:  Kč912.59
List Price:  Ft50,002.94
You save:  Ft14,287.57
SEK kr1,072.36
List Price:  SEK kr1,501.36
You save:  SEK kr428.99
List Price:  ARS$124,487.26
You save:  ARS$35,570.33
List Price:  Bs967.89
You save:  Bs276.56
List Price:  COP$536,181.17
You save:  COP$153,205.56
List Price:  ₡71,769.17
You save:  ₡20,506.94
List Price:  L3,461.75
You save:  L989.14
List Price:  ₲1,051,649.55
You save:  ₲300,492.76
List Price:  $U5,378.94
You save:  $U1,536.95
List Price:  zł551.05
You save:  zł157.45
Already have an account? Log In


Hello, in this video, I am going to discuss, you know, persistent data with SQL Lite. So what I've already done, I've got this code, perform the flutter documentation, and just as a table chord, the dogs in there basically in a more often dot application than a flutter application, what I want you to do once you know I've gone through, truly integrate this with a flutter based application. So that way, you can learn now the dots, you can learn some stuff and integrate together, you know, display something. So it's mostly it's all done it's, you know, displayed in here. reason I mean, I'm doing this for approach for you know, some of the videos in you know, brought into the end of the series. And we should, we're at the point where you should be able to, you know, get to grips with the code and adapt it yourself if at any stage of questions.

Now, just, you know, reach out and pop me a message. Okay so in the main we have essentially set the path to the database. So the name.db you could change this but obviously if you change it then you make sure you have to you have to make sure you always refer to that database Okay, then we have a little return so this is going to execute a certain command so this will feel familiar if you come from a web back end background three is creating table and we'll create called dogs. It's got a shoe free different columns on caller ID which he only accepts integers it is the primary key one called name which accepts text is basically anything and one is date and they just integer Okay, so the, you know, a bunch of different different methods that you can utilize for whatever you need.

You can adapt them beyond the for example class, that we insert dog, which you know, once you have The database, then you just do DB dot insert. And that takes you literally just specify the actual piece of information that you literally want to insert. So you specify the table name. And then you specify the actual, you know, data for dog to map. And then you know, if it's any confliction, it will just replace it in this case. And what else do we have?

So this is just generate the list which is printed out here, update dog, which, again, very similar, the table name, the data that you're using. So the actual column name needs to have date and where, what the what is comparing it to delete dog for you, I'm sure to figure out what that does. Okay, so by default, dog is this and that gets inserted as you can see right here, then happens is the age is slightly changed. And then a dog is updated, printed out, as in feed as an update. And if you were to delete it based on this ID, you can see that it there is nothing in the dog's name. So if I was to just put something like that, for example, the one that as you can see, because that didn't actually exist, Detroit is deleted, deleted, therefore we got one.

And you know, you can add in a more than one rose white if you wanted to. So we are going to have three rows now. Actually, that will not work because we see the ID on same. That's what I want you to do as an extra task is modify this so you can have multiple roles. It's just this but we have a different set of data because the ID is unique Again, integrate it into a flutter based visual application. So this is just a class to essentially, you know, store the data.

So once we get it from the database, we can store it into this and we can utilize it however we want. This is a slightly different style of video compared to the usual pace. But if you have any questions, feel free to reach out and I'm here to help you

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.