you can find me lurking in a few places 👻 https://t.co/w9emxHSJjA https://t.co/FqoVjLRpjd https://t.co/AiLq9nD74l https://t.co/jrDPxuPrQx https://t.co/1HFWh8NvCB https://t.co/igbWXNzLIz

I go over the setup of SQLite and extending it to support vector data. Then I go step by step on how to setup the database, from creating migrations using the Drizzle ORM and a custom migration system in Tauri -- to storing and accessing data in React frontend from Rust

In this blog I’ll break down how I added a SQLite database to my Tauri app, and specifically, how to use it as a vector DB to power a RAG system for LLM embeddings. Lots of great practical tips and tricks for working with SQL in Rust in this one. https://t.co/rv3PKtnxTK

If you're interested in taking a peek at the source code, I have it up on my Patreon for supporters. Keep your eyes peeled for the next blog post where I cover the database. https://t.co/gaX3Ltu4Wz

Here's a preview of the app that I made. You can add PDF or Markdown files to projects, then chat with a local LLM that you set up (like LM Studio). It's powered by a SQLite DB that handles storing document data and searching for relevant bits.

I go over the basics of LLM chats and the OpenAI API, like attaching docs. The process is actually simple: you paste the doc text into chat with a system prompt to inform the LLM about it. But with limited context, you can't just paste entire docs in. That's where RAG comes in.

Are you curious how LLM chat apps work? In my latest blog I break down how I created a local clone of Google's NotebookLM, and the intricate process behind exposing data to LLMs (aka "RAG") through vector embeddings and searching techniques. https://t.co/R0upB9DWyR

What’s up, I’m Ryosuke 🤘 I’m a creative technologist and available for hire. I recently worked at PlayStation prototyping for projects like PS5, PSVR2, PS App, and Portal. In my free time I make educational content about #3D, #GameDev, and graphics.

PlayStation appears to have just laid off an unspecified number of developers from its software division #PlayStation https://t.co/BkMqYT9XVU

Most of my team was just laid off from PlayStation. It was a dream to get to work with Sony on the platform I'd grown up playing since the PS1 and contribute to the PS5, Portal, PSVR2, PS App, and future consoles. If you know anyone who needs an engineer, feel free to reach out.

I’ll be honest, the other platforms have gotten so good I probably won’t be checking in here anymore. If you’d like to find me you know where ✌️

sly cooper heist caught on camera @SuckerPunchProd

🎀

I will legalize recreational marijuana, break down unjust legal barriers, and create opportunities for all Americans to succeed in this new industry.

Big things happening on the other side don’t miss it

Firewalk is signing off one last time. Firewalk began with the idea of bringing the joy of multiplayer to a larger audience. Along the way we assembled an incredible team who were able to: - Navigate growing a new startup into a team during a global pandemic: Firewalk was

so wild, I never would have expected this outcome. with how much money was invested - and honestly how good the game looked - it's amazing they couldn't find a way to turn it around. like this is going to go down in history as another E.T. game buried in some landfill.

got the screen shader migrated to ThreeJS. basically a couple PNGs with text stacked with animated UVs.

This idea is becoming increasingly awful from a control standpoint. I need to stop but I just like jiggling the fishing pole around so much

got my 3D MIDI piano (the "Ryoturia" 😉) exported from Blender to the web and wired up to play actual music #gamedev