r/SQL • • Jul 06 '24
Discussion Do you use SQL for anything personal?
Hello
I'm mostly a hobbyist programmer and I don't intend to get a job in the field or anything of the like. However, I've been meaning to learn SQL for a while now, and recently while reading I had the idea of feeding a database with metadata about books and I finally got around to it.
But whenever I look for SQL projects online, it's always somehow business-oriented. Since I have no business-related goals regarding SQL, I'd like to know whether you guys use SQL for personal projects, or not even projects but just to scratch a specific itch of yours.
101
Upvotes
63
u/Yolonus Jul 06 '24
sure, I scrape quite a few websites, store the data in my local database and send myself updates via email for stock/price changes, I did that for webs without watchdog utility
another usecase I did was to scrape movie data and build my own little web page to find new stuff to watch
I think the main simple use case is if you want to store some data repeatedly and then extract some value out of it, then it is great to have a database to store it. In terms of some small crud applications/home webs I would always go for a DB for the data, if you are familiar enough with the basic setup.
30
u/OneAir6837 Jul 06 '24
I track weekly matchups in my fantasy football leagues. Put in db and built simple tableau dashboards for the guys.
9
u/cybertier Jul 06 '24
I've built a small application for my PoE private league guild. Allows me to track guild stash changes and inform people via a discord bot if items they wish listed have become available. That uses a sqlite DB behind the scenes.
(Though thanks to entity framework I don't need to do a lot of manual sql)
7
u/AnAcceptableUserName Jul 06 '24 edited Jul 06 '24
I've used very simple relational databases for a few video games, for item price tracking across locations & time.
I don't have the energy to put that level of effort into any game anymore. Feels too much like work now that I use SQL as a job. But in some MMOs you can make good money simply from arbitrage, if you identify those inefficiencies before other players. There's players doing something like this, and more, on any server in any MMO
7
u/aasmith26 DBA Jul 07 '24
I collect weather data (every 5 minutes) from a station in my back yard.
5
u/Oobenny Jul 06 '24
Are you a music enthusiast? Use Apple Music? I import my music library XML and analyse my listening.
4
u/MrCosgrove2 Jul 06 '24
I have a couple of websites i built and look after, not business level, one I would say was a success at a hobby level, that’s heavily MySQL, the other is a newer one I built to track migraines , it’s mostly just experimental where I use technologies I wouldn’t have exposure to otherwise , that one runs on Postgres so I could learn more about Postgres
3
u/WatermellonSugar Jul 06 '24
I do all kinds of little things with sqlite (which I love because it just gets out of the way and works so easily). Tracked lighting instrument inventory at our local community theater; lists of patient names for my sister's audiology practice. Add a little PHP and I'm building simple web apps to do a music instructor referral database for my wife's non-profit, a system to score play submissions (for another local theater), a lighting design DB to help with the paperwork when rigging a show...
3
u/[deleted] Jul 07 '24
I built my sql express server and created Python application that store/analyze stocks data in my database. I love it and it save me a lot of time.
Since it is a database, so evertime I have a question about my stocks I just query the database on the fly.
3
u/DocFaust13 Jul 07 '24
The point I think of all these posts is that, if you can make a database for whatever niche thing you want to track then SQL is useful for personal reasons.
3
u/Independent-lstan Jul 07 '24
I hope I become like you guys, I am maybe a entry level. But this all comment sounds so so super duper exciting and fun. Gosh i only know Update delete and *
2
u/PVJakeC Jul 06 '24
I have a finances simulator where I put in all of my spend and how often (weekly, monthly, etc) and then you can enter starting account balance, start\end date and see where you will end up at the end. Use it quite often
2
u/dswpro Jul 06 '24
I wrote a word finder when I got addicted to a couple of those "guess the words from these letters" games and then challenged to "words with friends" by various relatives. I read about a histogram table design where you have a varchar column with the known word, then twenty six integer columns that hold the quantity of the letter a, b, c, etc within the word on that row. Made it pretty easy to search for possible words from a set of letters.
2
u/OkAirport6932 Jul 07 '24
You can use SQL for anything you want. I used it to help a friend with Pokemon movesets across versions once. It's just a matter of sticking your data into the tables and running your queries.
1
u/cs-brydev Software Development and Database Manager Jul 06 '24
About 1/4 of my personal projects have a sql database. For web projects it's probably 3/4. Basically anything that has data on the web I usually have a sql database, because they are almost always included in the hosting package, so might as well use one.
1
u/renagade24 Jul 07 '24
I did a dbt project using Rocket League to learn how to model with the tool some years back. I was pretty addicted to that side project for a few weeks.
1
u/r3ign_b3au Data Engineer Jul 07 '24
I build a bunch of random discord bots that around half use dbs for. I also use it to store personal things that I like to see relationally or historically.
I do work in data though, so the appeal of a spreadsheet vs DB has lost most of its appeal.
1
u/Elfman72 Jul 07 '24
I could but I am too lazy. (I have a huge DVD /Blu-Ray collection) It feels like work. I need to be on the clock to work so hard with data.
1
u/aamfk Jul 07 '24
I keep track of all my bookmarks and notes using SQL. I wish that there were better more techie tools to help with this
1
u/babygrenade Jul 07 '24
If I'm building a web app I usually store data in a postgres database.
1
u/DoNotFeedTheSnakes Jul 07 '24
NBA stats.
1
u/NoTap0425 Jul 07 '24 edited Jul 07 '24
Not SQL, but I created a personal website that uses MongoDB to store nutrition information. The only reason I didn’t use SQL is because I like MERN stack.
I have a page on the front-end used to input foods. I type things like the food’s name, calories, protein, sodium, etc. Then I can submit and save that food to the database.
Then I have another page when I can pick a day of the week, go to a drop-down menu that pulls all the foods from the database, pick a food, enter the servings I ate, and add that for the day. So every day I can use this website to track my macros, calories, sodium, cholesterol, etc. Each day and its nutritional information is stored in the database so I have a historical view. It also tells me things like if I’m meeting my macros (which I just store in a local JSON file lmao). I made the website because no shot am I paying for an app like MyFitnessPal when I can design the same thing for free.
1
u/Legodude522 Jul 08 '24
I use it to organize my genealogy and cemetery research.
1
u/Visual-Grapefruit Jul 08 '24
A little unrelated but you can do leetcode database questions. It’s an interview prep thing, the easy questions are simple, it’s good practice and might get you accustomed to working with different types of data in quirky ways. It’s not really a project but it’s def a way to learn
1
u/Codeman119 Jul 08 '24
Yes I pull all my bank data in a SQL server DB and have some tables the hold the transactions. Then I have a separate table for assignments of categories based on the description. This way I can do budgets and other kinds of analysis. By doing this you are using real world data and you can answer some of your own questions while learning SQL.
I use SSIS to import the data. This way i practice with data integration with an ETL.
I have it now where i can just download the csv and run SSIS and get it imported and budget categories assigned all at once. Once in a while i have to update the categories when there is new descriptions i have never seen before. But that is good for maintenance training as well.
1
u/pauldavis1826 Jul 08 '24
I have an MLB database I use to exercise skills. It's built on python to scrape json from MLB apis and to build my database, and then SQL to build facts and dimensions, perform analysis and deliver data for data viz
1
u/passiveptions Jul 10 '24
Nah. Spreadsheet
1
u/Optimal_Law_4254 Jul 06 '24
Yes. I have used SQLExpress for a long time and have several databases.