Although **Expo** offers a **SQLite** local database connection API, it is not very practical to use, especially for larger projects with more complex database designs since all it has is an *execute* function where you can write raw queries to be ran. With that in mind and having had some experience with **TypeORM** on the backend before, I wanted to see what it would be like to combine the two. Luckily, TypeORM already offers an `expo` driver and it's setup looks very easy. Nevertheless, I still had some problems while trying it out. This article's main goal is to be a walkthrough of the setup and things to keep in mind so that you don't go through the problems I did. Some of the tips are workarounds, some are optional and others are just necessary. --- Before procceeding there are some caveats to be made: * this tutorial assumes that you already know the basics of React Native; * it also assumes that you know how to create, run and publish an Expo project; * if the structure chosen for the project ever feels excessive, it's because I'm aiming to keep it organized and give it scalability; * if at any point you feel lost please refer to the [repository](https://github.com/jgabriel1/expo-sqlite-typeorm-article). All files and topics named in this article, will be there in the form of commits; * lastly, this is all a result of my experience while I was first learning it, so if you find something that is just clearly wrong please message me or send it in the comments. --- # The Application The application we'll be working on in this article is as simple as it can be. The [**main component**](https://github.com/jgabriel1/expo-sqlite-typeorm-article/blob/pre-persistence-implementation/src/components/TodoList.tsx) will hold a state for a list of To-Dos. The items can be **toggled** on/off, **deleted** and there is an input to **create** a new item: ```tsx const TodoList: React.FC = () => { const [newTodo, setNewTodo] = useState(''); const [todos, setTodos] = useState([]); const handleCreateTodo = useCallback(async () => { setTodos(current => [...current, { text: newTodo, isToggled: false }]); setNewTodo(''); }, [newTodo]); const handleToggleTodo = useCallback(async (index: number) => { setTodos(current => current.map((todo, i) => { return index === i ? { ...todo, isToggled: !todo.isToggled } : todo; }), ); }, []); const handleDeleteTodo = useCallback(async (index: number) => { setTodos(current => current.filter((_, i) => i !== index)); }, []); return (

jgabriel1

Expo SQLite + TypeORM

Join Our Newsletter. No Spam, Only the good stuff.