More progress on my DMLogger replacement :slight_smile: I have the following python code working to listen for UDP messages and stuff them into a database table. import socket import datetime import psycopg2 UDP_IP = "0.0.0.0" UDP_PORT = 29298 sock = socket.socket(socket.AF_INET, socket.SOCK_DGR…

Probably want to take advantage of python3’s async/await capabilities. And probably don’t want to be opening and closing a database connection for every packet.

I’ll check out the async/await functions. Yeah, I wasn’t sure that was the best approach for DB connections. My concern was the connection timing out. There will probably be times when it will be a day or two between packets (weekends with no one actively operating equipment). I figured the DB c…

I have updated code for everyone to amuse themselves with :slight_smile: I switched to asyncpg for the postgresql connection library. Looked like it was easier to use with async/await. The code still has plenty of print statements and is probably my worst copypasta from various online sources in …

Well, I made a couple of modifications to the code posted above. I moved the line that grabs a pool connection to the while loop in the consumer function, just after the await queue.get() line. This will grab a new connection from the pool when it’s ready to use it. I also replaced the asyncio.sl…

Ha, for a minute there I thought you had this running under Jython (2.5, no less! if the 7.9 tag is accurate) and it broke my brain because I just couldn’t believe it.

Sorry Kevin! Lol, I should have been a little more clear about where I was running this. It’s in a python 3.8 environment with the appropriate modules installed. Had to put on my big boy pants! So, really, Ignition doesn’t have anything to do with this bit of code, other than that’s what I’ll be…

Made a couple more modifications. We had power problems at the plant today, and it revealed a corner case (more with my db than the code here). The column holding the message was setup as text in postgresql, and apparently it doesn’t like holding null characters (not NULL values, just 0x00 charact…

Python code check

General Discussion

pturmel March 8, 2022, 10:28pm 6

Looks pretty good!

How to store longer json strings in tag history?