Geogi / web-pg-designer

A POC of an Electron-based (with ReactJS) PostgreSQL graphical database manager.
0 stars 0 forks source link

Prepared SQL statements #8

Closed Geogi closed 4 years ago

Geogi commented 5 years ago

All of the queries to information_schema (currently almost all of them) could be prepared instead of rebuilt using JS every time.

Geogi commented 4 years ago

Because prepared statements only last for the duration of the session, we cannot guarantee they will be available at a later point when getting a client from the connection pool (if would have to be the client that prepared the statements, never a fresh one). We could introduce some kind of fault-tolerant, lazy system but due to the interactive native of the soft, it will likely never be truly useful.

Closing.