I started Práctica de Vocabulario as a fun little project for my portfolio to show what I can do in backend web development (you hiring?). The rest of my website uses MariaDB, so as I was beginning the process of creating the Spanish-English dictionary, I just tacked it on to the existing site. As I started adding the words to the database, I got an error saying the entry for ácero is a duplicate and violates the UNIQUE constraint on the word field.
Anki is a flashcard program - you create (or download!) decks of cards to study. I used it a ton in undergrad history and language courses and it's now my go-to study app. It's available for desktop and mobile for free (with the exception of the $25 iOS app). Práctica de Vocabulario (PdV) walks users through the process of creating their own deck of Anki vocabulary flashcards for Spanish books they want to read.
You need a SQL database for your web application, but you need something more permanent than SQLite and less expensive than a managed cloud-based instance like Snowflake. Using Docker to deploy your SQL database is straightforward and relatively inexpensive, especially if your web application is already deployed in Docker. In this post, I'll cover the steps to create a MariaDB instance in Docker using Docker Compose.
It finally happened: your boss has insisted you learn SQL to help with a new project. You've got plenty of Excel experience, but databases seem so foreign and you're not sure where to even start.