Arthur Busser · [email protected]

Some more thoughts on Infrastructure as Code, and how little has changed in 30 years. @bgrant0607/infrastructure-as-code-reminds-me-of-make-run-all-15eb6628f306" target="_blank" rel="nofollow noopener">medium.com/@bgrant0607/in…

@_StanGirard @AntWilson @supabase Could it be that you’re not reusing previous connections? Connection pooling may help here, if you’re not already doing it

@AntWilson i just finished some investigations. It seems there is a TLS handshake in PostgRest happening at each request. It doesn't happen locally because no HTTPS. The queries are very fast on Supabase, but it seems there is no caching for the handshakes in subsequent queries and it adds around 60ms each time Is that something I could have misconfigured ? When you do the same queries directly on the database by using SQLAlchemy it is very very fast. Here is the profiling:

Am I doing something wrong with my @supabase ? A query takes 60ms in production where it takes less than 0.5ms locally Any insights ? I'm in Paris on AWS and supabase in Ireland. @AntWilson 👀

@JulienBreux I tried to do this with Midjourney and got disappointing results. Whatever you end up using, I’d love to hear about your experience :)

What AI tools can I use to create the logo of my next Open Source project? Thanks 🙏

Do you think machines will soon write code just as well as us humans? Do you think LLMs are how machines will learn to code well?

It's very cool to see machines improve their ability to write code. It seems like they have caught up with a significant portion of the world's programmers, but not yet with many more. They still have a lot to learn.🧠

Copilot used a regex that didn't work, so it ended up missing a lot of words. Even when told that the solution was wrong, Copilot never suspected that the issue was the regex it had written. Pro tip: triple check your regular expressions; write tests for them!

ChatGPT wouldn't find any digits written as words. Its code iterated over each character in the line and looked them up in its word-to-number map; looking up individual letters never yielded any results... 🙈

Can AI replace software engineers? 🤖 Not yet. LLMs get stuck on the first day of the #AdventOfCode! After I solved today's problem myself, I decided to see how well ChatGPT 4 and GitHub Copilot Chat would do. Here's what happened. 🧵

But their implementations were buggy... There were subtle mistakes that made their solutions yield results that were way off.

Once I gave them the second part of the problem statement, they started to design a solution. Their solution was pretty much the same: find both numerical and alphabetical digits in each line, map them to numerical values, and then do the math. So far so good! 👍

ChatGPT and Copilot both wrote working solutions to part 1 on the first try! 👏👏 This didn't surprise me. The first days of the #AdventOfCode are pretty simple and don't require complicated algorithms to solve. What I didn't expect, was for AI to get stuck on part 2! 🤯

ChatGPT wrote in Python because I let it choose whatever language it wanted. Copilot wrote in Go because I had a Go file open.

I gave them both the problem statement for today's first part, as it's written, with minor formatting changes to make it as clear as possible, as well as my own input. They both fully understood what they were being asked to do.

I told ChatGPT and Copilot I wanted to do an experiment, to see how well they could write code to solve increasingly complex logic problems. ChatGPT was really into it! 🤩 Copilot did not care at all... 😐

😎Welcome @ndubien, Author of fast-check.dev & Software Engineer @GoPigment! Can't wait to see you at React Day Berlin: reactday.berlin