Hoyuo Study Log Help

13. Database with SQLite

232. Intro database sqlite sqflite

233. Look up in sql

234. Position of sqflite and drift

235. Sqflite in flutter

236. Create db instance

237. Database singleton

238. Open database

239. Create tables

240. Init and access database

241. Init and access stream database

242. Recap json serialization

243. Create recipes ingredients parser

244. Find all recipes from db

245. Find recipe by id in db

246. Find all ingredients in db

247. Find recipe ingredients in db

248. Watch all recipe with stream function

249. Watch all ingredients from db

250. Insert recipe into db

251. Insert one ingredient

252. Create base insert method

253. Create base delete method

254. Delete recipe

255. Delete ingredients

256. Delete ingredients for a recipe

257. Close stream database

258. Sqlite repository with repository interface

259. Insert recipe with ingredients

260. Delete data

261. Delete recipe and ingredients

262. Open and close database

263. Ignore param in json serializable

264. Fix sql syntax(cons of sqflite compare to drift)

Last modified: 30 May 2024