Database transformation from SQL Server to YugabyteDB

A database transformation and migration project takes solid planning and testing. I’ve found that three common changes required when transforming a SQL Server database to YugabyteDB YSQL are related to syntax, performance, and stored procedures. These will get you started on your transformation project. Syntax Transforming a schema from MS SQL to YugabyteDB requires...

Which Open-Source Database?

I’m an open-source database consultant. But which open-source database? Well, several of them. I made the decision several years ago to take every opportunity to work with multiple databases. Why? This was the kind of database consultant I intended to be — providing value to engineering teams by guiding them to the right system,...

Processing Data with Pandas

I’ve been experimenting with processing data with Pandas this week, specifically historical NOAA weather data, and storing it in a local YugabyteDB cluster. This open data set contains max/min/precipitation for years back to 1750 (not all data points are available for all years or locations). It’s available here: https://www.ncei.noaa.gov/metadata/geoportal/rest/metadata/item/gov.noaa.ncdc:C00861/html I leveraged my existing demo...

Foreign Data Wrappers

I was recently setting up a demo to show off query logging features. Two common extensions, pg_stat_statements and pg_stat_monitor, store data locally. In the case of a distributed database, it is helpful to combine the query runtimes on all nodes. YugabyteDB supports foreign data wrappers, so I decided to use this feature to combine...

String Search

Quick post to share my presentation last week at the YugabyteDB Friday Tech Talk. It was on fuzzy matching, and more generally string searches. Got to nerd out on two of my favorite topics: words (broadly, linguistics and specifically, names) and databases. Check it out! (Code for scenarios in my repo, here: https://github.com/dataindataout/xtest_ansible/tree/main/scenarios/fuzzy)

Audit Logging

Gearing up for my next YFTT presentation next month. It will be on fuzzy matching, a chance to show out some neat string search features. Meanwhile, here’s the deck for my last YFTT. The topic was audit logging. https://info.yugabyte.com/hubfs/YFTT%20Slide%20Decks/2022_12_02_YFTT_Valerie%20Parham-Thompson_Audit%20Logging%20in%20YugabyteDB.pdf Audit logging is just one of the security features available in YugabyteDB. You can use...