Databases on iOS: Making queries to SQLite in Swift (SELECT, INSERT, UPDATE and DELETE) - Tutorial

preview_player
Показать описание
Using the example of an iOS mobile application, we will learn how to execute database queries (SELECT, INSERT, UPDATE and DELETE) to SQLite using the Swift programming language. The library of toolkit GRDB will help us.

  1. Igor Shapkin
  2. Database
  3. DB
  4. BD
  5. iOS
  6. SQL
Рекомендации по теме
Databases on iOS: 0:08:47

Databases on iOS: Making queries to SQLite in Swift (SELECT, INSERT, UPDATE and DELETE) - Tutorial

SQL : How 0:01:09

SQL : How to query an external SQL database - iPhone app

Which Database Type 0:18:15

Which Database Type Should I Use For My App?

How to view 0:01:11

How to view SQLite database backend for Core Data | iOS Programming | Swift

SQL Explained in 0:02:23

SQL Explained in 100 Seconds

37-SQLite swift#3.Insert and 0:10:43

37-SQLite swift#3.Insert and query all data in SQLite Database Swift 4

Choosing the Right 0:25:08

Choosing the Right Cloud Database For Your Indie iOS App | Mikaela Caron | 360iDev Conference 2022

iOS MySQL | 0:00:34

iOS MySQL | Insert into database through iOS App | iOS-MySQL

𝗚𝗲𝗻𝗲𝗿𝗮𝘁𝗲 𝗦𝗤𝗟 𝗳𝗿𝗼𝗺 2:37:01

𝗚𝗲𝗻𝗲𝗿𝗮𝘁𝗲 𝗦𝗤𝗟 𝗳𝗿𝗼𝗺 𝗡𝗮𝘁𝘂𝗿𝗮𝗹 𝗟𝗮𝗻𝗴𝘂𝗮𝗴𝗲 - 𝗕𝗲𝗴𝗶𝗻𝗻𝗲𝗿-𝗙𝗿𝗶𝗲𝗻𝗱𝗹𝘆 𝗚𝗲𝗻 𝗔𝗜 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝘄𝗶𝘁𝗵 𝗚𝗶𝘁𝗛𝘂𝗯 𝗖𝗼𝗱𝗲!...

iOS 7 Tutorial 0:12:39

iOS 7 Tutorial 18 - SQLite Databases Part 1

SQLite: Creating a 0:06:53

SQLite: Creating a database in an iOS app

Vector databases are 0:03:22

Vector databases are so hot right now. WTF are they?

Sqlite Database crud 0:01:19

Sqlite Database crud with swift 5 iOS | FMBD | Sqlite insert fetch update delete

What's an App 0:30:07

What's an App Without Data? | iOS Conf SG 2023 | The Database Options for iOS Apps

Google Database Program: 0:25:07

Google Database Program: Demo Cloud Firestore NoSQL Database for iOS

Apple: iPhone app 0:01:20

Apple: iPhone app to manage MySQL databases

INT(11) is a 0:01:00

INT(11) is a lie #database #mysql #coding

Querying Databases | 0:03:07

Querying Databases | Glide Apps Tutorial

Best way to 0:02:22

Best way to create iOS database with MobiDB database app for iOS.

15 futuristic databases 0:08:42

15 futuristic databases you’ve never heard of

Access an Oracle 0:00:31

Access an Oracle 11g Database via iOS

Full Stack iOS 0:54:42

Full Stack iOS Notes App - Setting up Database and Web Server (Lesson 1)

Intro to Databases 0:20:43

Intro to Databases (MySQL, CloudKit, Firebase, Core Data, Realm)

iOS 7 Tutorial 0:16:14

iOS 7 Tutorial 19 - SQLite Databases part 2

Комментарии
Автор

Thanks Igor - I'm a beginner, helps me a lot! I was looking at crazy complicated shit before I saw this...

andrewkemp
Автор

Nice video! Helped me a lot with databases. Thank you!

Yulyusha
Автор

I run your code but i got error while line number 74 i got fatel error if suppose i change this ! - > ?? "" i didn't get any output

-ECE--VIGNESHN
Автор

Привет, у меня вопрос я могу создать в любой СУБД БД(Например в PostgresSQL) и потом её так использовать как в видео ? Заранее спасибо.

zheniaserhatyi
Автор

I have some misunderstanding, so I`ve no errors, but data from my database doesn't display in table view, maybe you can help me, please

AlinaVovkovynska
Автор

Igor I have a question: how did you connect the outlets in the ProductTableViewCell to the main view? Mine won’t connect and the app is not working as a result (it runs but shows no data).
Second question, did you use a DBHelper to set the OpaquePointer, and change AppDelegate to connect to the database?
If you can answer 😊 Thankyou!

andrewkemp