1 day - Research which database to use first on the deployed user systems

Question

1 day - Research which database to use first on the deployed user systems

Opened this issue 4 years ago · 16 comments

freeman42x commented 4 years ago

Quests:

read about all the different types of databases and comparisons between them:
- https://www.indeed.com/career-advice/career-development/types-of-databases
- https://www.geeksforgeeks.org/types-of-databases/
add pros/cons to this Kialo: https://www.kialo.com/which-is-the-best-database-for-software-that-can-do-anything-47792?path=47792.0
find which DB is optimal to add first for our use-case of eventually creating Human-Level AI

GanttStart: 2021-03-28
GanttDue: 2021-03-29

Answer 1 · 2021-03-07T09:28:31.000Z

opaleye only supports postgresql which is what I would have picked anyway so i vote using postgresql

Answer 2 · 2021-03-08T20:18:02.000Z

Idk I always used MySQL and it always worked, so I guess I'm gonna vote for MySQL?

Answer 3 · 2021-03-15T09:01:01.000Z

@F15Ky which other databases did you look at before choosing PostgreSQL?

Answer 4 · 2021-03-15T09:03:50.000Z

@F15Ky afaik and according to this and other resources MS SQL is better than PostgreSQL for our goals: https://db-engines.com/en/system/Microsoft+SQL+Server%3BPostgreSQL

Answer 5 · 2021-03-15T09:05:43.000Z

See also: https://stackshare.io/stackups/microsoft-sql-server-vs-postgresql

Answer 6 · 2021-03-15T09:08:36.000Z

@F15Ky please provide justifications for why PostgreSQL is a better choice than MS SQL, Oracle DB, etc.

Answer 7 · 2021-03-15T09:13:04.000Z

I would say any of those would be a good fit, but i'd choose postgres because it is open source. Here is a more detailed comparison https://www.enterprisedb.com/blog/microsoft-sql-server-mssql-vs-postgresql-comparison-details-what-differences "We conclude that SQL Server has historically been popular with organizations that rely on other Microsoft products, but PostgreSQL has risen to the top of the field not only because of the advantages of going open source but also for its robust features and active community of users. "

Answer 8 · 2021-03-15T09:14:50.000Z

@F15Ky this is a very important decision: just being open source is not sufficient reason to use it as MS SQL Server for example is way superior in many ways. Please do proper research before deciding on a DB for us to use

Answer 9 · 2021-03-15T09:16:55.000Z

here's some more comparision for context
https://www.janbasktraining.com/blog/oracle-sql-server-mysql-and-postgresql/
PostgreSQL supports more platforms compared to the others

I vote for postgreSQL as well

Answer 10 · 2021-03-15T09:17:58.000Z

@npc203 this is a very important decision: just being open source is not sufficient reason to use it as MS SQL Server for example is way superior in many ways. Please do proper research before deciding on a DB for us to use

supporting more platforms is irrelevant, we only need to deploy it on 1 platform

Answer 11 · 2021-03-15T09:18:47.000Z

We can do proper research now which should only take a few hours and choose a close to optimal DB or choose one without proper research and then waste months or years on fixing the chaos we created in the future

Answer 12 · 2021-03-15T11:34:10.000Z

@F15Ky @npc203 We will use Kialo to do proper research into which DB to use:

https://www.kialo.com/which-is-the-best-database-for-software-that-can-do-anything-47792?path=47792.0

Answer 13 · 2021-03-15T11:42:06.000Z

Project M36 is interesting: https://www.reddit.com/r/haskell/comments/7tx0o4/haskell_3_sql/dtga90d?utm_source=share&utm_medium=web2x&context=3

Answer 14 · 2021-03-15T11:51:23.000Z

@F15Ky @npc203 we should look at something more generic than Databases actually

for example, storing data on the blockchain or similar methods of distributed and resilient storage

at minimum, we need to keep that in mind when deciding on a DB

Answer 15 · 2021-03-16T16:25:54.000Z

@F15Ky @npc203 @holytanx list of DB ranked: https://db-engines.com/en/ranking

Answer 16 · 2021-03-16T17:03:34.000Z

https://db-engines.com/en/system/H2%3BHyperSQL%3BSQLite