Valerie Parham-Thompson
@dataindataout.bsky.social
database architect · database architecture for teams ready to launch and scale · speaker & writer readme at valerieparhamthompson.com
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...
Extended Statistics in Postgres
Using extended statistics helps improve performance for queries in postgres.
valerieparhamthompson.com
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!
Washing Machine Repair - Replacing the Inlet Valve (LG Part # 5221ER1003A)
YouTube video by PartSelect
youtube.com
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...
KubeCon Content Browser
Security Musings
dfeldman.org
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...)
STUDENT REGISTRATION -
congressionalappchallenge.us
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
yugabyte-db/managed/api-examples/python-simple/demo-user-management.ipynb at dss-demo · dataindataout/yugabyte-db
YugabyteDB - the cloud native distributed SQL database for mission-critical applications. - dataindataout/yugabyte-db
github.com
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...
Handling Reserved Keywords in DSBulk for Seamless Data Migration
Migrating to YugabyteDB offers significant advantages in terms of high availability, global distribution, and horizontal scalability—features essential for managing modern database workloads. However,...
valerieparhamthompson.com
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. :)
College Scorecard API
After I finished the YugabyteDB universe network mapping example, I started thinking about other things to map. Anything with latitude and longitude will work. College locations from my previous work ...
valerieparhamthompson.com
Using Plotly to create a simple database network map. Had fun with this one. valerieparhamthompson.com/posts/plotly...
Plotly Network Map
I’ve added a new feature to the day 2 ops tool. With the diagram command, you can create a map of your Yugabyte cluster overlaid on a map of the world. Here’s an example: The Plotly library is very po...
valerieparhamthompson.com
Code as a way to ramp up new users of database software. www.valerieparhamthompson.com/posts/code-a... #python #CLI #typer #databases #replication
Code as Instructional Technology
I’ve had the chance to share my database expertise in a variety of venues: speaking at meetups and conferences, leading hands-on workshops, mentoring new technologists, and of course writing. I had be...
valerieparhamthompson.com
Which open-source database? www.valerieparhamthompson.com/open-source-...
Which Open-Source Database? - Valerie Parham-Thompson | Open-Source Database Consultant
This was the kind of database consultant I intended to be -- providing value to engineering teams by guiding them to the right system, helping them architect the most performant database solution, and...
valerieparhamthompson.com
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...
Database scaling for seasonal increases - Valerie Parham-Thompson | Open-Source Database Consultant
Five things to consider as you prepare your database scaling to support temporary increased demand.
valerieparhamthompson.com
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...
Using College Scorecard Open Data - Valerie Parham-Thompson
Personal experience using College Scorecard open data for a college search in 2023, using custom fields not on college search website forms.
valerieparhamthompson.com