T-SQL Tuesday #113 – What Do YOU Use Databases For?

T_SQL_Tuesday

This month’s T-SQL Tuesday is about what do YOU use databases for in your personal life that you are willing to share?

We work with data all day and sometimes all night long. When we turn off work, some of us continue to use data and databases to enhance our professional growth and learning. I know on some days the last thing I want to look at after work is- another screen full of data. Kinda of like how some auto mechanics have poorly running cars. How can that be? Because they work on cars all day long and they are tired of working on cars- including their own.

But I’m curious- outside of work and learning, what do you personally use databases for? Tracking books you have, recipes, collections, etc? While it can be said using databases for personal use could be either overkill or a hammer in search of nails on the other hand, it is exactly what they are for- storing data.

Years ago I challenged my daughter- I would give her $100 to go through a book about databases, sit her in front of SQL Server Developer Edition, and we would build a database to track our VHS collection. (VHS, heh, yes I’m old. Now get off my lawn).

We used a book called The Manga Guide to Databases.

CoverBack

It was great except they used the non-ANSI syntax for joins…

non_ansi

We whiteboarded and created a simple database.

The experiment was a ton of typing. And linking to the movies in Wikipedia. And then capturing some information about personal family events based on date. BTW, she is now a film student in college.

More than twenty years ago I was into FileMaker Pro working for a defense contractor. We needed a way to store many pictures about launch site equipment. It was my first time trying to figure out: a) how to store pictures in a database b) how to store metadata about the pictures and c) how to search and retrieve the pictures. There was no auto-tagging, object recognition or any sophisticated technology to help me out. So I used what tools I knew about. The project was a success but took way more time than I would have liked.

I am into pictures and have been looking at ways to store and retrieve them for quite some time. Some things work and some things don’t work so well. On 06Apr19, I will be presenting in Colorado Springs, Colorado for SQL Saturday on Storing Images in a Database – Tips and Techniques.

As I learn more about Python I’ll be able to do more sophisticated things. Like the kind of things I couldn’t do twenty years ago. One of them I want to tackle is how to extract text out of images. Ever see people taking pictures during a presentation with their smartphones? Or see code in a YouTube video? How do you get the text of the code out? Most people I think would say they just re-type it. But what if you could use software to do that for you? So I’m fiddling with Python-tesseract.

So what do you use databases for in your personal life that you are willing to share? Blog about it. I’m curious to see the range of uses and even if you don’t use databases for personal stuff, what do you see as the future of organizing personal data?

All Good Things Must Come to an End

T-SQL Tuesday has the following rules:

  1. Publish your contribution on Tuesday, 09Apr19 between 00:00 UTC to 23:59 UTC.
  2. Include the T-SQL Tuesday Logo and have it link to this post.
  3. If your post doesn’t link back, please comment below with a link to your post.
  4. Tweet about your post using the #tsql2sday hashtag.
  5. Please consider hosting! If so, get in contact with Steve Jones ( blog | twitter ) to get your name on the list!
This entry was posted in Uncategorized. Bookmark the permalink.

12 Responses to T-SQL Tuesday #113 – What Do YOU Use Databases For?

  1. Pingback: T-SQL Tuesday #113 – What Do You Use Databases For? – T-SQL Tuesday

  2. kchant1975hotmailcom says:

    Here’s my T-SQL Tuesday contribution for this month https://www.kevinrchant.com/2019/04/09/t-sql-tuesday-113-what-i-use-databases-for/

  3. Pingback: T-SQL Tuesday #113 – What Do YOU Use Databases For? – Reitse's blog

  4. Pingback: Making Databases Personal | SQL RNNR

  5. Pingback: T-SQL Tuesday #113: A year of marriage and boardgames - SQLGene Training

  6. Pingback: Follow-up to T-SQL Tuesday #113 – What Do YOU Use Databases For? | Todd Kleinhans

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s