I took a look at extended statistics in postgres. An effective way to share with the query planner things you know about relationships in your data. With math! www.valerieparhamthompson.com/posts/extend...
Valerie Parham-Thompson
Valerie Parham-Thompson
@dataindataout.bsky.social
database architect · database architecture for teams ready to launch and scale · speaker & writer readme at valerieparhamthompson.com
309 followers801 following21 posts
I'm so grateful that folks take the time to record DIY videos on youtube, especially when I can save time and money based on what they've already figured out. Earlier this week I used Steve's video to repair our washer www.youtube.com/watch?v=RUnz.... Thank you, Steve!
Today I had a chance to contribute back to the DIY community when I couldn't find a video about replacing the driver-side seat panel on our Subaru Crosstrek. Like most things, the replacement was super easy once I figured it out. www.youtube.com/watch?v=uWzp...
I'm sharing how to pinpoint YugabyteDB APIs you need for automation projects through docs categories, keyword search, UI route mapping, and source code exploration. valerieparhamthompson.com/posts/findin...
Worked on a new jupyter notebook today for retrieving expiration dates and counts from various certificates in YugabyteDB, using the control plane APIs. Going to gather a few more of these before I submit the PR. github.com/dataindataou...
A guy jogged past me this morning on the trail wearing a #kubecon 2024 tshirt. All the way back home here in North Carolina! Well, it reminds me about this project, which links to the talks on YouTube, with some other neat features. dfeldman.org/post/2024-11...
One of my favorite volunteer gigs is judging submissions for Congressional App. Can't wait to see who wins for our district. Such impressive ideas & implementations -- we're in good hands with the upcoming generation of technologists. (For next year: www.congressionalappchallenge.us/students/stu...)
Committed this new example Jupyter notebook for Yugabyte REST APIs yesterday, for local platform user management. github.com/yugabyte/yug... #python #yugabytedb
One of the API examples I shared during the Distributed SQL Summit last week: github.com/dataindataou... Longer transcript and walkthrough coming. #yugabyte #distributed #sql #livedemo
Discover the future of cloud-native distributed databases at #KubeCon + #CloudNativeCon in Salt Lake City. Let's meet at booth M11. lnkd.in/efw632nE Stop by to discover why #PostgreSQL-compatible, distributed, #YugabyteDB is the ideal database choice for #cloud-native applications.
Migrating data from one database management system to another? Watch the reserved keywords. #datamigration #schema #modernization valerieparhamthompson.com/posts/reserv...
New blog post outlining the details of calling the College Scorecard API to get #opendata and displaying results using #python on a map using the Plotly library. valerieparhamthompson.com/posts/colleg... I'm looking around for more things to map, because this is fun. :)
Using Plotly to create a simple database network map. Had fun with this one. valerieparhamthompson.com/posts/plotly...
Code as a way to ramp up new users of database software. www.valerieparhamthompson.com/posts/code-a... #python #CLI #typer #databases #replication
Which open-source database? www.valerieparhamthompson.com/open-source-...
Preparing your database for seasonal demand requires thinking ahead… setting up monitoring for your workload, knowing how long it takes to implement scaling, and doing predictive forecasts. www.valerieparhamthompson.com/database-sca...
Most college search websites present forms that are too limited in search terms and subject you to marketing. Turns out, they use open data from the US Department of Education, and you can use this data directly. www.valerieparhamthompson.com/open-data-co...
You are up to date.