Show HN: Mathesar – open-source collaborative UI for Postgres databases

• mathesar

  53 2,196 9.9 Python

  Web application providing an intuitive user experience to databases.

  

Yes! We have set up a Postgres template database[1] with our demo data sets. When a user logs in, we create a new database based on the template database and associate the database with the session key set up for that login. So every session is associated with a different database and we have some Django middleware that routes you to the URL associated with your session's database. If you log out and log back in (thus ending your session), you'll be routed to a brand new database.

However, all databases are accessible to the demo user, so if you create a link and send it to someone else, they will see your database (since the URL includes the database identifier).

You can see our code for it here: https://github.com/centerofci/mathesar/tree/develop/demo

[1] https://www.postgresql.org/docs/current/manage-ag-templatedb...

• pydantic

  167 18,617 9.8 Python

  Data validation using Python type hints

  

I haven't because I'm Python biased. ;)

Have you ever tried [Pydantic](https://docs.pydantic.dev) with mypy!? It may be what you need for type safety / data validation.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• pydantic_schemaorg

  1 45 0.0 Python

  Schema.org classes in pydantic

  

JSONLD types are specified with @type, and the range of a @type attribute includes rdfs:Class.

icontract and pycontracts (contracts-based programming) have runtime type and constraint checking; data validation. Precondition, Command, Postconditions (assertions, assertions of invariance after command C_funcname executed)

pydantic_schemaorg: https://github.com/lexiq-legal/pydantic_schemaorg

> Pydantic_schemaorg contains all the models defined by schema.org. The pydantic classes are auto-generated from the schema.org model definitions that can be found on https://schema.org/version/latest/schemaorg-current-https.js... [ https://github.com/schemaorg/schemaorg/tree/main/data/releas... ]

• schemaorg

  45 5,227 8.3 HTML

  Schema.org - schemas and supporting software

  

JSONLD types are specified with @type, and the range of a @type attribute includes rdfs:Class.

icontract and pycontracts (contracts-based programming) have runtime type and constraint checking; data validation. Precondition, Command, Postconditions (assertions, assertions of invariance after command C_funcname executed)

pydantic_schemaorg: https://github.com/lexiq-legal/pydantic_schemaorg

> Pydantic_schemaorg contains all the models defined by schema.org. The pydantic classes are auto-generated from the schema.org model definitions that can be found on https://schema.org/version/latest/schemaorg-current-https.js... [ https://github.com/schemaorg/schemaorg/tree/main/data/releas... ]

• beekeeper-studio

  59 15,274 9.8 TypeScript

  Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

  

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project