Avalon local LLM

[Pocster]

Gone back a bit to codex as scout and patch suggester ! . Chat validates if patch is good . Codex tends to wander a bit but when it works it works ! . Saves a bit of time . Still have pi harness and local 120b as fallback .

More impressive was minstrel ! Understanding properly implied time  “ play Coldplay from yesterday “ , “ play Coldplay album I played last Tuesday “ , “ play album I had on last evening “ . Not linked to Postgres yet nor lms playback ( chat refuses to jump testing first !!! ) . Minstrel also extremely good at “mis hearing “ e.g whisper translate so “ play yeller by foldplay” gets converted correctly !

Edited 21 hours ago by Pocster

[MikeSharp01]

18 minutes ago, Pocster said:

Not linked to Postgres yet

I have been an SQL server & MYSQL user until about a month ago when one of my students was showing me some work they were doing on a knowledge hub with Postgres and I thought I should give it a go for my next mini project idea and I found it very good all kinds of ways the pgAdmin software is excellent.

[SimonD]

10 hours ago, MikeSharp01 said:

I have been an SQL server & MYSQL user until about a month ago when one of my students was showing me some work they were doing on a knowledge hub with Postgres and I thought I should give it a go for my next mini project idea and I found it very good all kinds of ways the pgAdmin software is excellent.

Same here, plus Sqlite and Maria DB. Open Heat Loss has been my first project using Postgres and it's great, especially the way cloud hosting providers like Railway support it natively - makes life a breeze. Although for me the only thing has been learning its quirks at the application layer so had a few issues there - but that's just learning any new DBMS.  

[Pocster]

1 hour ago, SimonD said:

Same here, plus Sqlite and Maria DB. Open Heat Loss has been my first project using Postgres and it's great, especially the way cloud hosting providers like Railway support it natively - makes life a breeze. Although for me the only thing has been learning its quirks at the application layer so had a few issues there - but that's just learning any new DBMS.  

I’m not a DB person as it’s boring stuff . Only using Postgres as chat suggested it . If it works and I haven’t got to look at it I’m happy 😃 

[SimonD]

1 hour ago, Pocster said:

I’m not a DB person as it’s boring stuff . Only using Postgres as chat suggested it . If it works and I haven’t got to look at it I’m happy 😃 

Boring yes, but also essential. The problem is that you might just end up with shite database design that's poorly normalised as I've found that AI is typically lazy when it comes to entity relationship modelling, preferring to chuck stuff in as JSON without much thought instead of distinct columns and rows, and also needs to be told when to properly use one-many & many-to-many relationships. This is because it can't deal with the full context of a development and it has to be fed smaller components and steps. I made the mistake letting it create my DB on its own to begin with and then we had to have words, after which it created a proper entity relationship diagram and model that I could review and approve. Unfortunately because I didn't feed in my DB design in at the start, we're up to something like DB migration 017 (in Postgres but about 11 more on previous DBMS as well as a full DB re-write) which wouldn't have happened if I'd known all this to begin with. At least it will write all the migration scripts, but not without a handful of crashes on deployment.

This is kind of why I'm still surprised you haven't had to touch any code at all with your project.

Edited 5 hours ago by SimonD

[Pocster]

15 minutes ago, SimonD said:

This is kind of why I'm still surprised you haven't had to touch any code at all with your project.

I’m surprised also . If DB is shit ( or indeed anything else ) I assume chat 5.6 will sort out 5.5 mess ! 😂