thousandsofthem
Custom ecto/postgrex types for Point data type?
At this moment postgrex package have built-in point data type (geometric, not a PostGIS one), according to the source code:
https://github.com/elixir-ecto/postgrex/blob/master/lib/postgrex/builtins.ex#L74
https://github.com/elixir-ecto/postgrex/blob/master/lib/postgrex/extensions/point.ex
I’m trying to use it with Ecto, no luck so far. Is there a way to use it in ecto schema? Regular way (Postgrex.Types.define) doesn’t seem to work for me
Marked As Solved
thousandsofthem
UPD: created custom ecto wrapper, seems to be working correctly. No idea why no one did that before
defmodule App.EctoPoint do
@behaviour Ecto.Type
def type, do: Postgrex.Point
# Casting from input into point struct
def cast(value = %Postgrex.Point{}), do: {:ok, value}
def cast(_), do: :error
# loading data from the database
def load(data) do
{:ok, data}
end
# dumping data to the database
def dump(value = %Postgrex.Point{}), do: {:ok, value}
def dump(_), do: :error
end
Also Liked
thousandsofthem
Sure. Besides, geo_postgis is for PostGIS stuff (separate package, not installed by default), not a regular point .
e.g. PostGIS’ Geo.Point includes coordinates and srid projection, different data type.
PostGIS makes sense if someone goes full-blown geographic approach, for more humble use-cases (e.g. sort stuff by distance to a person, sped up by an index) point is more than enough
josevalim
That looks great. Also see the geo_postgis library: GitHub - felt/geo_postgis: Postgrex Extension for PostGIS · GitHub 
josevalim
I see. Thanks for clarifying!
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #javascript
- #code-sync
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"