Local SQLite Database for Expo React Native App with Import and Export Database from Device Files

Hi everyone!

Today I am going to show you how to create an app that connects to a local database. I will cover the basic CRUD operations of creating (insert), reading (select), updating (update) and deleting (delete) records. I will also cover creating a table.

Sometimes you may want to import/export your database so I will also cover this.

If you would like to see my expo-sqlite example, the source code is available on my GitHub:
https://github.com/chelseafarley/expo-sqlite-tutorial

For the expo-sqlite documentation you can see the expo documentation:
https://docs.expo.dev/versions/latest/sdk/sqlite/

To learn about sqlite queries:
https://www.sqlitetutorial.net

// ABOUT ME
My name is Chelsea and I started studying software engineering in 2010. I have been working commercially full time since 2014 and have been in various positions from graduate developer to tech lead to solution architect.
I’m a full stack developer with a lot of experience in C# and Javascript but my passion is for mobile development; specifically native iOS development and cross platform using React Native.

I always have many things on the go and am always trying out a new side hustle and failing at it; perhaps you can learn from my mistakes!

Please like and subscribe if you enjoyed this video and want to see more like it!
Have any suggestions on topics you would like to learn more about? Please suggest them in the comments… I would love to help you out while doing a bit of learning myself!

// PRODUCTS USED
I use the following products in the creation of my videos:

Boya MM1 Microphone – https://amzn.to/3er9Ivl
A reasonable quality and reasonably sturdy but cost effective microphone that can be used by both DSLR cameras, mobile phones and laptops

Canon 18-55mm Lens – https://amzn.to/3RG1YUo
A kit lens but a decent quality lens for beginners getting used to a DSLR

Canon EOS Rebel T7 with 18-55mm Lens – https://amzn.to/3RmmY2W
This is the kit I started with it includes the lens linked above and is a great starter camera.

I love Apple devices… These are the ones I use for my channel content creation:

Apple iPhone 13 – https://amzn.to/3KOqLmW
A good all round phone, good for Apple development and recording videos with enough high quality features but at a cheaper price point than the pro versions.

Apple MacBook Pro – https://amzn.to/3KNkcBc
A nice portable computer for working from anywhere and perfect for iOS development

Apple iPad Air 4 – https://amzn.to/3qhfKkR
Really easy to use for graphic design if required for logos as part of my app development or editing the videos on the go.

Apple Pencil (2nd Generation) – https://amzn.to/3D05NQc
For logo and icon design in Affinity Designer app for iPad

Logitech Folio Keyboard Touch for iPad Air 4 – https://amzn.to/3BhQrpd
Adds keyboard and touchpad to iPad Air 4, making it easier to use for writing code/eBooks etc. on the go!

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to provide you with free content each week!

//CONTACT:
Please contact me at: [email protected]

//CRAVING MORE:
All my code on github can be used for whatever purposes, if I have neglected adding a license let me know and I can fix that right up: https://github.com/chelseafarley
Want an insight to my personal life? Follow me on instagram: https://www.instagram.com/curlingcharlz/
And here’s my website: https://tripwiretech.com/