Full ALPR Database System for Blue Iris!

@MikeLud1 I'm not sure if your models have this or not, but I believe some of the others have an option under the ... on the right of their row to "download model" or have the different sizes.

This could be a nice way to do it when you update it. That can allow users to download the newest model without updating cpai. Also don't remember exactly what for or where, but I've also seen things about needing to set no-cache for the download. Maybe that's part of the dropdown menu? Not sure.. You would know. But just a suggestion to make it easier. Updating codeproject on linux is pretty streamlined, but I remember it being an enormous pain on windows, so if that could be avoided just to update the model, that could probably be very helpful.
I was in talk with Chris from CodeProject on an AI model database where user can download the models right from the CodeProject.AI Dashboard. The changes would needed be on the server side along with the modules. Currently the Object Detection (YOLOv8) module is the only module that has the option to download models. We were looking at hosting the models on Hugging Face as an option.
 
Last edited:
  • Like
Reactions: algertc
Docker Compose Plugin for Unraid worked. Thanks
Can you share what you used in the Unraid Docker Compose Plugin --> Edit Stack --> Compose File and any other things you edited? I am having issues with the Postgres portion =/
1739918360297.png



The one issue I am seeing in the Postgres logs are:
Code:
/var/run/postgresql:5432 - no response
 
Last edited:
  • Like
Reactions: algertc
Can you share what you used in the Unraid Docker Compose Plugin --> Edit Stack --> Compose File and any other things you edited? I am having issues with the Postgres portion =/
View attachment 214869


The one issue I am seeing in the Postgres logs are:
Code:
/var/run/postgresql:5432 - no response
If you read along further in the thread, you will see that I did not get this working despite long hours of trying. You can also look on the github discussion about it. I ended up using an Unraid VM with Linux and it works great
 
  • Like
Reactions: algertc
If you read along further in the thread, you will see that I did not get this working despite long hours of trying. You can also look on the github discussion about it. I ended up using an Unraid VM with Linux and it works great
Thanks for the lead. It looks like I got it working in unraid now:

1740004495881.png



Here are my container configs for reference:


1740004933141.png

1740004958900.png

I was getting some errors in the logs. Once I ran the migrations per Olympia in the github discussion everything was working. Based upon MY postgresql config settings here is what I ran in the postgres console:

Code:
psql -U postgres -d postgres -f /migrations/migrations.sql
 
Last edited:
Thanks for the lead. It looks like I got it working in unraid now:

View attachment 214938


Here are my container configs for reference:


View attachment 214939

View attachment 214940

I was getting some errors in the logs. Once I ran the migrations per Olympia in the github discussion everything was working. Based upon MY postgresql config settings here is what I ran in the postgres console:

Code:
psql -U postgres -d postgres -f /migrations/migrations.sql
glad it worked... I don't think im going to rock the boat with my config right now
 
glad it worked... I don't think im going to rock the boat with my config right now
Exactly. If it ain't broke, don't try to fix it. Some of my containers feel like they were built atop a house of cards and don't need it crashing down :lmao: .
 
@algertc @MikeLud1 I have an old database of license plates from using the Rekor and local sql tool, OpenALPR Tool - Save and Query CSV Exports.
Do you happen to know if I can bring those into ALPR Database? I have some captured from PlateMinder too. Is there a guide on importing previously captured plates?
 
@algertc @MikeLud1 I have an old database of license plates from using the Rekor and local sql tool, OpenALPR Tool - Save and Query CSV Exports.
Do you happen to know if I can bring those into ALPR Database? I have some captured from PlateMinder too. Is there a guide on importing previously captured plates?

@VideoDad was able to do this with a python script that used a csv. It's in this thread like 10-15 pages back somewhere. Maybe take a crack at that? Not too many people have previous recognitions prepared like this, so it's not my top priority to integrate directly into the app, but possibly at some point.
 
Any YouTube video related to this project to help newbies? I have a powerful pc and good cameras but don’t how to use this type of stuff ☹️

I made this a while ago. It is outdated and doesn't include the new storage directory, but the process is still basically the same. If you read through the readme instructions along with it, it should be fairly clear. The video explains what is going on and how to get started.

Note that in this video the docker-compose.yml file was a codeblock in the readme. I removed it from the readme when I created the installation scripts to keep things more up-to-date. You will just need to click on the file in the repository to view it. Here's a link also: compose file
 
@VideoDad was able to do this with a python script that used a csv. It's in this thread like 10-15 pages back somewhere. Maybe take a crack at that? Not too many people have previous recognitions prepared like this, so it's not my top priority to integrate directly into the app, but possibly at some point.
No problem. Thanks I'll look for it.

I added a request on your roadmap for adding cars that don't have license plates. Thanks again for a great tool. Do you have a buy me a coffee link or similar?
 
  • Like
Reactions: Skinny1
Thanks again for a great tool. Do you have a buy me a coffee link or similar?

No need! :) All I ask is that you star the GitHub repo. I enjoy working on it and am glad others are able to use it.

I added a request on your roadmap for adding cars that don't have license plates.

Better color/make/model detection may be coming soon. I’ll work something out to allow no plate to be accepted for a setup like you described in the request.
 
No need! :) All I ask is that you star the GitHub repo. I enjoy working on it and am glad others are able to use it.
Done!! I didn't know this was a thing.
 
  • Like
Reactions: algertc
No need! :) All I ask is that you star the GitHub repo. I enjoy working on it and am glad others are able to use it.



Better color/make/model detection may be coming soon. I’ll work something out to allow no plate to be accepted for a setup like you described in the request.

Starred!

Thanks. Let me know if I can be a tester for that feature =)
 
Last edited:

cant find this part log into the application. what application? i'm using windows. installed Docker Desktop and Git Bash. i'm lost.​

Get Your API Key​

To start sending data, log in to the application and navigate to settings -> security in the bottom left hand corner. At the bottom of the page you should see an API key. Click the eye to reveal the key and copy it down for use in Blue Iris.
 

cant find this part log into the application. what application? i'm using windows. installed Docker Desktop and Git Bash. i'm lost.​

Get Your API Key​

To start sending data, log in to the application and navigate to settings -> security in the bottom left hand corner. At the bottom of the page you should see an API key. Click the eye to reveal the key and copy it down for use in Blue Iris.

point your browser to the