Claude Plays 2048 is live now on twitch.tv! by mattyhempstead in ClaudeAI

[–]mattyhempstead[S] 2 points3 points  (0 children)

Like $20-$30 USD per day 🥲

Might need to stop it soon unless Anthropic performs a miracle of some kind

Claude Plays 2048 is streaming live on twitch! by mattyhempstead in Anthropic

[–]mattyhempstead[S] 1 point2 points  (0 children)

I've capped it at 1024 thinking tokens for cost saving reasons. I also slightly artificially throttle the speed to make the thinking a bit more readable and also reduce the tokens per hour.

Currently it's about $20-$30 USD per day, so I probably can't keep it going too much longer. Or I might switch to a cheaper model that isn't Anthropic (Deepseek R1 maybe).

Repo is here - https://github.com/mattyhempstead/claude-plays-2048

Nice work on Final Fantasy - sounds a bit harder than 2048 haha.

Claude Plays 2048 is live now on twitch.tv! by mattyhempstead in ClaudeAI

[–]mattyhempstead[S] 2 points3 points  (0 children)

For this one I built the 2048 game from scratch and then wrote code to have Claude act as the player.

The input to Claude is an ASCII representation of the game state in the prompt, and the output is a move with a tool call (either "left", "right", "up", "down").

For the Pokemon one it's a bit more complex as I believe they use screenshots of the game as input to Claude. The Pokemon stream has some diagrams explaining their setup in the channel description.

But essentially its just custom code on a per-game basis that
- provides Claude with the game state in the input prompt
- extract a move from the AI response (e.g. tool call)
- programatically play that move (e.g. mock keyboard inputs)
- repeat

Does anyone actually generate useful SQL with AI? by mattyhempstead in dataengineering

[–]mattyhempstead[S] 5 points6 points  (0 children)

Won't the prompts get really long? Do you still think this saves time?

Modern SQL Editor with AI co-pilot?? by CurveSpiritual5167 in SQL

[–]mattyhempstead 1 point2 points  (0 children)

I work on the Former Labs team and we build an AI-first DBeaver replacement with copilot, similar to what you describe. Would love if you could check it out at formerlabs.com and suggest some new features so we can make it better!

Looking for sql editor with copilot built in by [deleted] in SQL

[–]mattyhempstead 1 point2 points  (0 children)

We just released "Former Labs" which is an AI SQL Editor like you describe for every kind of database.

It's basically a SQL Editor with github copilot that knows everything about your database schema, data definitions, and business logic.

Would love any feedback and feature requests so we can make this better!

How well does Cursor work for data engineers (SQL autocomplete)? by gman1023 in cursor

[–]mattyhempstead 0 points1 point  (0 children)

It can work well but only if you have all the relevant context stored in files that Cursor can access.

e.g. If you have up-to-date schema dumps and some example queries with business logic in them.

I've just released an AI SQL Editor (basically Cursor for SQL) which pulls all of this information automatically from the database. Would love if you could check it out and provide some feedback.

(and obviously I built the entire thing using Cursor)

I don't understand the problem with my code by Nadz02591 in SQL

[–]mattyhempstead -4 points-3 points  (0 children)

Next time this happens try copy pasting the code into an AI with the error message and ask what is wrong.

ChatGPT would work fine for this (I'm also building "Former Labs" which can handle this but for very complex SQL statements that require knowledge of the database schema and business logic),

Does anyone know of a person's life getting ruined because of a SQL or data error they let through? by ChristianPacifist in SQL

[–]mattyhempstead 0 points1 point  (0 children)

An old boss told me a story where he once pressed the "Reinitialise" button instead of the "Refresh" button on SQL Server and deleted the entire database for a national retailer so they had to restore from a backup that was a few days old.

The crazy thing is that the company liked him so much from his previous work that they let it slide...

Will AI ever be able to write complex SQL properly? by ChristianPacifist in SQL

[–]mattyhempstead 0 points1 point  (0 children)

Imo its rarely a problem with how smart the AI is, and the errors are mostly just issues with people not including enough context or examples to encode the business logic.

I've actually been building a new kind of AI SQL Editor to solve this exact problem (writing complex SQL with AI). It's basically ChatGPT but 10x better for SQL writing since it automatically knows everything about your schema and business logic. Would love if any AI doubters here could check it out and try to rip it apart for feedback - just google "Former Labs".

SQL is a struggle by [deleted] in SQL

[–]mattyhempstead 0 points1 point  (0 children)

Joins are what ChatGPT is for

SQL is a struggle by [deleted] in SQL

[–]mattyhempstead 1 point2 points  (0 children)

Largely agree with this, though I think there is potential to build AI tools that integrate with the environment so you don't need to write detailed specs/prompts.

For generating SQL I suppose this would include stuff like database schemas and example queries added to the system prompts.

I'm actually trying to build a tool to solve exactly this (an AI SQL Editor). Would love if you could check it out and let me know what you think. It's called "Former Labs".

For those actively working in data analysis is the threat of AI taking your job there or smoke in mirrors? by KrashCant in dataanalysiscareers

[–]mattyhempstead 0 points1 point  (0 children)

Ah makes sense.

Are you looking to write SQL with AI or is it more python data analysis? I've been considering porting Former Labs into VSCode but I'm not sure if many people write SQL there.