search

schollz / find3

High-precision indoor positioning framework, version 3.
https://www.internalpositioning.com/doc
MIT License
4.63k stars 364 forks source link

Run find on aws #131

Open imtoori opened 5 years ago

imtoori commented 5 years ago

There is a way to run find on docker on aws using one of the aws databases?

victorhooi commented 5 years ago

Find3 currently uses SQLite3 - I'm not sure if there's an easy way to repoint it to an external SQL server.

@schollz might know more.

ffedee7 commented 5 years ago

I had to rewrite the Go SQL module and modify some queries in order to use Postgres (inside AWS) on find3.

victorhooi commented 5 years ago

@ffedee7 Oh - are you able to share those modifications please? (even if rough).

This seems like it would be incredibly useful!

I'm keen to see if some of my scalability issues go away if I move from SQLite to Postgres.

ffedee7 commented 5 years ago

@victorhooi Hi, sorry for the late answer. Yes, my repo is https://github.com/ffedee7/posifi The problem is that since we don't need the family concept, we deleted it (we use a single hardcoded family). Since find3 uses one database per family, we decided to use the PostgreSQL database to our single family.

The changes were, change the SQL module from SQLite to the Postgres one and modify some queries.