postgrex
AdventureWorks-for-Postgres
postgrex | AdventureWorks-for-Postgres | |
---|---|---|
3 | 2 | |
1,050 | 0 | |
0.8% | - | |
6.6 | 10.0 | |
16 days ago | over 1 year ago | |
Elixir | PLpgSQL | |
Apache License 2.0 | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
postgrex
-
Elixir clustering using Postgres
Now we can replicate the same behavior in Elixir and Postgrex within IEx (Elixir's interactive shell).
-
TIL: Non standard postgres types in livebook
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.
-
Realtime: Multiplayer Edition
It sounds like Supabase is pulling out the WAL listening bits into its own library?
https://supabase.com/blog/supabase-realtime-multiplayer-gene...
If so, y'all might want to look into: https://github.com/elixir-ecto/postgrex/blob/master/lib/post...
AdventureWorks-for-Postgres
-
Reverse engineer unknown data format using elixir
I recently worked on porting the csv file converter for AdventureWorks database from ruby to elixir. This ended successful and I have all the data in my local postgresql to play with. By browsing the tables I found spatial_location column in person.address table and I wanted to decode it.
-
TIL: Non standard postgres types in livebook
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.
What are some alternatives?
ecto - A toolkit for data mapping and language integrated query.
eventstore - Event store using PostgreSQL for persistence
mariaex - Pure Elixir database driver for MariaDB / MySQL
mongodb_ecto - MongoDB adapter for Ecto
amnesia - Mnesia wrapper for Elixir.
couchdb_connector - A couchdb connector for Elixir
ecto_psql_extras - Ecto PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
neo4j_sips - Elixir driver for the Neo4j graph database server
github_ecto - Ecto adapter for GitHub API
ecto_migrate - Automatic migrations for ecto
mongodb - MongoDB driver for Elixir
paper_trail - Track and record all the changes in your database with Ecto. Revert back to anytime in history.