TIL: Non standard postgres types in livebook

• postgrex

  3 1,047 6.3 Elixir

  PostgreSQL driver for Elixir

  

But I found a problem when the data type is not supported by postgrex. In this case, you can either have to write a custom postgrex extension like the example here. In postgrex GitHub repo, there are many examples for common data types, but XML is missing there.

• AdventureWorks-for-Postgres

  2 0 10.0 PLpgSQL

  Set up the AdventureWorks sample database for use with Postgres (by QuerySorcery)

  

To play with this example, you can install the example Adventureworks database provided by Microsoft. I made an elixir converter that converts some of the files to a format accepted by PostgreSQL, and also updated the previous version to properly name the columns with underscores.

• 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