Changing the default search language in RDS
•
til
Full text search in PostgreSQL is pretty great!
Recently, though, I found a bug in my application that perplexed me. When I searched for the word …
Read more →Hello, I'm Dave
I've spent most of my career in the weird interstices of government, technology, and public policy. Now, I write about whatever interests me!
Latest Writing
Recent thoughts on law, technology, and building better systems
How to remove *some* duplicates from a dataframe
•
til
I have a dataframe that has contains duplicates. And although I wanted to get rid of many of the duplicates, I also wanted to keep some duplicates on …
Read more →How to use `scan_csv` with a file-like object in Polars
•
til
I have a case where a bunch of CSVs are stored together in a zip file and I want to convert those CSVs into a parquet file. I’m using polars …
Read more →Using python map() instead of pandas .apply()
•
til
Recently, I was playing with a rather large dataset using pandas and trying to improve the performance of my code. While reaching for the …
Read more →A bit about me
I'm an expert in how the federal government works and brings a rare blend of experience as a software developer, lawyer, and product strategist. These days, I mostly consult, write, and build software to help companies navigate procurement.
Procurement
Government
Technology
Public Policy
Read my full story
Stay in touch
Interested in my thoughts on government technology, legal innovation, or building better systems? Follow along via RSS or connect with me on social media.