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

[freeman42x]

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

[F15Ky]

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

[rozbrajaczpoziomow]

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

[freeman42x]

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

[freeman42x]

@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

[freeman42x]

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

[freeman42x]

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

[F15Ky]

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. "

[freeman42x]

@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

[npc203]

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

[freeman42x]

@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

[freeman42x]

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

[freeman42x]

@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

[freeman42x]

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

[freeman42x]

@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

[freeman42x]

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

[freeman42x]

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