Joined May 2024
52 Photos and videos
Pinned Tweet
I've just posted a new video: Text-to-SQL: Create Logical Plans & Prune Your Schema w/ piglets & Apex-SQL. This video is the first time sharing a modular text-to-SQL toolkit I've been working on called piglets. See comments.
1
1
1
347
I found this episode genuinely cathartic. There’s tons of stuff in here particularly w.r.t balancing coding agent enabled pace vs quality.
Why is the creator of OpenCode pretty skeptical about AI productivity gains, and the hype around AI? A very conversation @thdxr (and lots of truth bombs:) Timestamps: 00:00 Intro 07:03 Dax’s path into tech 09:04 Early startup experience 13:16 Getting involved with open source 16:13 OpenCode 23:17 Anthropic banning OpenCode 30:34 From terminal to GUI 32:34 OpenCode’s business model 36:33 Why inference is profitable 39:11 GPU bottlenecks 40:54 AI hype 45:50 AI spending 48:47 Dax’s memo 55:41 Dax’s skepticism of predictions 58:58 Engineering culture at OpenCode 1:02:38 How building works at OpenCode 1:05:36 Taste and quality 1:11:32 Dax’s work setup 1:12:35 The role of engineers and EMs 1:15:50 Advice for engineers 1:18:12 Book recommendation Brought to you by: • @AntithesisHQ – verify your system’s correctness without human review or traditional integration tests – and avoid bugs or outages antithesis.com/pragmatic@WorkOS – everything you need to make your app enterprise ready workos.com/@turbopuffer – a vector and full-text search engine built on object storage. It’s fast, cheap, and extremely scalable turbopuffer.com/pragmatic Three interesting thoughts from Dax: 1. No AI-native coding agent company is “winning” by being better with AI. Dax says that none of OpenCode’s competitors are crushing them, and that nobody is using AI so well that others cannot compete. 2. Most software engineers profit from AI as time gained, not increased output — unless you change incentives! Dax says the natural way for software engineers to “cash out” their AI tooling gains is with time savings, by doing the same work as before, but faster. Until compensation and motivation structures change, most teams should expect output to stay flat while engineers go home earlier. There’s nothing wrong with this, but AI vendors sell a different outcome to CFOs: increased output. 3. AI code generation mutes the “guilt” of doing the wrong thing, but this builds up tech debt. Pre-AI, writing a hack felt bad, the second time it felt really bad, and by the third time you’d often just refactor in order to fix up the code. Now, the agent hides the hack, which skews devs’ judgment and results in less tech debt being cleaned up.
1
34
My honest answer: my recommendation was weak. 😭😭😭
12
Decent morning
8
Not saying anything novel here, but, Codex /goal is really powerful.
19
piglets is a modular text-to-sql Python library. As of v0.1.16 you can use piglets for: - Logical Planning - Dual-Pathway Pruning - Semantic Linking - Data Profiling Check it out: github.com/mportdata/piglets
1
1
40
piglets is compatible with LLMs from: @openai, @AnthropicAI @GoogleDeepMind, @OpenRouter, @cohere, @MistralAI, @deepseek_ai and any others supported by @LangChain and Databases such as: @duckdb, @Snowflake, and any others supported by @sqlalchemy
1
71
“He’s listening to a podcast whilst doing chores, his hands just got dirty. Now have his iPhone switch from his AirPods to his car stereo.”
14
My current obsession is text-to-SQL, as a result I’ve started to build a Python package (piglets) that is a modular text-to-SQL library. The basis of this are the components of the Apex-SQL paper (which I’d also recommend checking out).
Text-to-SQL: using piglets to prepare your context with @duckdb and @openai In this video we use piglets 🐷 to prepare our context for the text-to-SQL step. It also demonstrates a new piglets primitive, Policies. youtube.com/watch?v=cNXm1t_4…
2
75
piglets is built using @LangChain for model providers @sqlalchemy for database connectors. As a result we already support all major LLM and database providers.
11
Something I had to overcome with piglets was integration tests and example notebooks that didn’t require specific databases to be pre paid for and pre populated. @duckdb and it’s TPC-H extension solves this perfectly.
27
Mike Porter retweeted
Text-to-SQL: using piglets to prepare your context with @duckdb and @openai In this video we use piglets 🐷 to prepare our context for the text-to-SQL step. It also demonstrates a new piglets primitive, Policies. youtube.com/watch?v=cNXm1t_4…
1
191
piglets v0.1.14 - Now includes Semantic Linking, this is a Text-to-SQL technique taken from Apex-SQL where we combine a schema agnostic plan with a database schema to produce schema specific guidance. github.com/mportdata/piglets
37
Mike Porter retweeted
Use piglets with Gemini-2.5-Flash to perform Logical Planning and Dual-Pathway Pruning on a TPC-H database in @duckdb
1
2
118
Adobe Premiere captions keep transcribing me as saying “Gemini-2.5-Flush”.
34
piglets is a modular text-to-SQL framework I'm working on. In this video we look at Logical Planning and Dual-Pathway Pruning and use piglets to use those to prune the schema of a @googlecloud @googcloudtech BigQuery dataset using gpt-5.2 from @OpenAI @OpenAIDevs. The approaches here are implementations of methods found in the Apex-SQL paper from @Bowen_Pony et al.
1
2
70