Full ALPR Database System for Blue Iris!

[VideoDad]

I think the code is stable, and Charlie hasn't had time to add new features. Maybe he'll come back or someone else will take up the challenge?

I just want to know that Charlie (@algertc) is okay. I know he was having health scares and a lot of life changes, a move, a new job and other pressures. Hopefully he'll stop by and give us an update.

 

[TheWaterbug]

I just want to know that Charlie (@algertc) is okay. I know he was having health scares and a lot of life changes, a move, a new job and other pressures. Hopefully he'll stop by and give us an update.

Ditto this.

But I'll also say that this ALPR application and database is exactly the kind of coding that AI excels at. And it's open source. To wit, scroll back a few pages and see the security hole that my Claude was able to detect and fix.

If anyone wants to throw some tokens at algertc's project, I'm sure it could add some of the requested features, easily.

 

[VideoDad]

Ditto this.

But I'll also say that this ALPR application and database is exactly the kind of coding that AI excels at. And it's open source. To wit, scroll back a few pages and see the security hole that my Claude was able to detect and fix.

If anyone wants to throw some tokens at algertc's project, I'm sure it could add some of the requested features, easily.

Charlie was in the process of creating a "Gen 2" version with a new database, a notification/rules engine, etc. and said he was very close. Anyone know if that is available to view and start testing? Maybe he can just jump into this conversation for a moment and give us an update and perhaps the best steps to offload the workload from him?

I know he said he doesn't have an active ALPR setup, but the rest of us do and would gladly give the gen 2 a go.

And with a little guidance from him on how to set up a dev environment, maybe a few of us could start learning and improving that version?

 

[prsmith777]

Ditto this.

But I'll also say that this ALPR application and database is exactly the kind of coding that AI excels at. And it's open source. To wit, scroll back a few pages and see the security hole that my Claude was able to detect and fix.

If anyone wants to throw some tokens at algertc's project, I'm sure it could add some of the requested features, easily.

GitHub - prsmith777/ALPR-Database-Community: Fully-Featured Automated License Plate Recognition Database Platform for Blue Iris + CodeProject AI Server

ALPR-Database-Community/CHANGELOG.md at main · prsmith777/ALPR-Database-Community

Fully-Featured Automated License Plate Recognition Database Platform for Blue Iris + CodeProject AI Server - prsmith777/ALPR-Database-Community

github.com

ALPR-Database-Community/docs/COMMUNITY_PRODUCT_ROADMAP.md at main · prsmith777/ALPR-Database-Community

Fully-Featured Automated License Plate Recognition Database Platform for Blue Iris + CodeProject AI Server - prsmith777/ALPR-Database-Community

github.com

Ive been on this for over a month with Codex. Ive added tons of stuff and its working well but its kind of specialized for my setup so I dont know if it would work for others. I also have no idea how it could be implemented by others...sorry Im new at all this

 

[samplenhold]

He has not signed in since June 8th.

 

[swebster]

Somehow part of your database schema didn't get updated to the latest version. Try manually reapplying the schema.sql and migrations.sql.

• Grab the updated schema.sql and migrations.sql directly from the ALPR-Database GitHub Repository.
  Move the fresh files into your local host directory mapped to the container.
  Access your database container console and run:
  psql -U postgres -d postgres -f /migrations/migrations.sql

I got it working by manually modifying the schema. I know next to nothing about sql, but I kept feeding the results into Google's AI, and, the REALLY scary thing is, after doing everything it suggested, I flipping got it working.