search

jopache / Settings

Hierarchical Settings Application
Apache License 2.0
3 stars 1 forks source link

Move to a more free/open database #9

Open jopache opened 7 years ago

jopache commented 7 years ago

Need to look in to Postgres, MySql, (start with SQL Lite?) as this will be moving to a cheap and small Linux VM. Needs to have a low CPU/Memory footprint. Needs to have a decent EF provider for EF Core 2.0. I'm curious about Postgres' json support. SQL Lite might be okay to start with as it would save me time of setting up a db server on my box.

JaredEnglert commented 7 years ago

Check out mongoDB.

jopache commented 7 years ago

Matt T. almost convinced me to move to neo4j and it sounds like the better overall fit, however, I think this app could gain more traction if it was in SQL because companies usually feel like they can more easily maintain/control SQL. Once you throw out NoSQL solutions or unknowns, some are likely to turn away or be afraid.

JaredEnglert commented 7 years ago

Or support multiple...

jopache commented 7 years ago

EF would theoretically allow me to swap out the provider and support SQL Server, Postgres, MySql, etc allowing me to support multiple ;-)

jopache commented 7 years ago

24 adds support for postgres toggleable via config.