ppvan / psequel Goto Github PK

Update connection save and load logic

• Update CRUD query, add cert_path column
• Find a solution to update local database in old version of the app

Update import and export action

Should fixed #44

• Make edit dialog
• Gather table info to build modify query
• Add modal dialog for insert new row
• Update row
• Delete row

Error message when trying to connect with SSL toggled on.
invalid sslmode value: "required"

Downloaded from Flathub, 0.2.0

I can list my schemas, but I can't list my tables or run any queries while using posgres using docker. Is there something I'm missing?

This is my system info :

NAME="Pop!_OS"
VERSION="22.04 LTS"
ID=pop
ID_LIKE="ubuntu debian"
PRETTY_NAME="Pop!_OS 22.04 LTS"
VERSION_ID="22.04"
HOME_URL="https://pop.system76.com"
SUPPORT_URL="https://support.system76.com"
BUG_REPORT_URL="https://github.com/pop-os/pop/issues"
PRIVACY_POLICY_URL="https://system76.com/privacy"
VERSION_CODENAME=jammy
UBUNTU_CODENAME=jammy
LOGO=distributor-logo-pop-os

Docker Image Info: postgres:latest
version: '3.9'

services:
postgres:
image: postgres:latest
container_name: postgres-container
ports:
- '5432:5432'
environment:
POSTGRES_USER: ${POSTGRES_USER}
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
POSTGRES_DB: ${POSTGRES_DB}
volumes:
- pgdata:/var/lib/postgresql/data
- ./init-scripts:/docker-entrypoint-initdb.d

volumes:
pgdata:

Sequeler might be useful to look at for this https://github.com/Alecaddd/sequeler

Do you have permission to use the PostgreSQL logo as part of your logo? If no, please stop using the PostgreSQL logo. https://www.postgresql.org/about/policies/trademarks/

I would also suggest you contact Postgres to see if they consider the name psequel an infringement on their trademark. It certainly implies an affiliation in my mind. [email protected]

• Restore database from backup created by backup feature

I think this might be similar to #68:

psequel:2): Psequel-WARNING **: 16:23:53.181: Schema.vala:54: Regex not match: CREATE INDEX subscribers_fxa_profile_json_subscriptions_idx ON public.subscribers USING gin (((fxa_profile_json -> 'subscriptions'::text)))
**
Psequel:ERROR:../src/models/Schema.vala:55:psequel_index_extract_info: code should not be reached
Bail out! Psequel:ERROR:../src/models/Schema.vala:55:psequel_index_extract_info: code should not be reached

This started occurring after I ran this:

CREATE INDEX CONCURRENTLY subscribers_fxa_profile_json_subscriptions_idx ON subscribers USING GIN ((fxa_profile_json->'subscriptions'));

Changes

• Drop old table structure view
• Find a way to express equalvilent infomation in graph (By using color to indicate PK, tooltip for index and graph itself for FKs)

Preview:

Copying entire rows or a column value is not working on the "Data" view and neither in the query result, it would be very useful to copy values. Please consider implementing this.

Issue: Current version show view info as tabular data, not convient to view or reason about

Expect: Have a context menu for each table item: "Graph" to show visual schema

Hello,

This app looks great and I'm excited to try it out, but when I try and use an SSL connection in the Flatpak version I get the following error:

sslmode value "require" invalid when SSL support is not compiled in

Would compiling from source resolve this? Am I missing a flatpak dependency?

Using version 0.1.3

• Implement fetch data with filter
• Validate WHERE filters
• Auto completion for table columns
• Fix not sync with pagination

Sequeler might be useful to look at for this https://github.com/Alecaddd/sequeler

• Ability to backup your database like pg_dump
• Copy table DDL can also be added
• Export database schema

Changing the color scheme in preferences doesn't change anything in the UI on v0.1.6 installed from Flathub. It doesn't output any error message either.

Due to current implementation, open 2 window at the sametime not work.

• Allow query with params
• #5
• #7
• Add keyboard short cut for oparations
• About window and flatpak deployment
• #14
• #10
• #12
• Run query using Ctrl +
• #17
• Query History
• #21
• #15

I get this error when running from console:

(psequel:2): Psequel-WARNING **: 20:37:13.508: Schema.vala:54: Regex not match: CREATE INDEX table_columnid ON another_table USING btree ("table_id")
**
Psequel:ERROR:../src/models/Schema.vala:55:psequel_index_extract_info: code should not be reached
Bail out! Psequel:ERROR:../src/models/Schema.vala:55:psequel_index_extract_info: code should not be reached

Issue: Have to input connection infomation by hand

Expect: If you have a valid connection string, there should be a option to parse that and fill to the form

• In the preferences, font family, color scheme, and all options hang on functioning. So, If I change something and then close the preference panel, it hangs on.
• After table creation, the created table does not show on the left side, on reload, or on logout. Tables only show when on the quit psequel app and then run.

If any additional information or logs are needed to diagnose the problem, please let me know and I'll be happy to provide them.

It would be useful to be able to connect to remote databases over SSH Tunnel.

It would be great to see how many tables are in the database just like it shows number of rows.

• Validate query using postgres parser
• Optimnize the query building into a separate service (allow build select, update and delete query)
• Optimize Relation class to better handle query result data

class SQLQueryBuilder:
    def __init__(self, table_name):
        self.table_name = table_name
        self.query = ""
        self.where_clauses = []
        self.order_by = ""
        self.limit = ""

    def select(self, columns):
        self.query = f"SELECT {', '.join(columns)} FROM {self.table_name}"
        return self

    def where(self, column, operator, value):
        where_clause = f"{column} {operator} '{value}'"
        self.where_clauses.append(where_clause)
        return self

    def order_by(self, column, order="ASC"):
        self.order_by = f"ORDER BY {column} {order}"
        return self

    def limit(self, limit_value):
        self.limit = f"LIMIT {limit_value}"
        return self

    def build(self):
        query = self.query
        if self.where_clauses:
            query += " WHERE " + " AND ".join(self.where_clauses)
        if self.order_by:
            query += " " + self.order_by
        if self.limit:
            query += " " + self.limit
        return query

# Example usage
query_builder = SQLQueryBuilder("users")
query = query_builder.select(["name", "email"]) \
                     .where("age", ">", 25) \
                     .where("city", "=", "New York") \
                     .order_by("name") \
                     .limit(10) \
                     .build()

print(query)

Things i want to add in next version:

• Remove themes and add light/dark preview #52
• SSH turnel (i current duno wtf is this, but i'll try)
• CSV import/export (many possible with postgres COPY command)
• implement an sql LSP client (not sure i have enough time)
• Find a way to test the app -> not possible
• Data cell should be copiable, context menu if needed