plotly / falcon

Free, open-source SQL client for Windows and Mac 🦅
https://plot.ly/free-sql-client-download/
MIT License
5.13k stars 278 forks source link

Failed to connect Falcon to Postgresql #644

Open DarrenMidson opened 6 months ago

DarrenMidson commented 6 months ago

Hi

I have created a postgresql database on my windows 10 laptop and I can read and write data from the database via Python.

code snipnet

conn = psycopg2.connect(database="Test", user='postgres', password='xxxxxx', host='127.0.0.1', port= '5432')
conn.autocommit = True
cursor = conn.cursor()

cursor.execute('''insert into esptemp values(%s,%s, %s)''', (UDP_PORT, datetime.now(timezone.utc), float(writestring)) )

cursor.execute('''SELECT * from ESPTEMP''') However, I want to be able to display the data using plotly Dash which requires, I think, their Falcon software to connect.

But when I run falcon and try and connect to my database I get

Unknown authenticationOk message typeMessage { name: 'authenticationOk', length: 23 }

Help greatly appreciated

Regards

Darren