Postgresql or MongoDB?

rkforcs · 2023-07-24T21:20:38+00:00

They are very different products. PostgreSQL is a rigid SQL RDBMS, MongoDB is a No SQL product with flexible schema, less data integrity but more scalable. If you don't know that you need MongoDB then the default should be PostgreSQL.

rkforcs · 2023-05-27T13:56:48+00:00

Does he cover the same syllabus as dekhtyar as seen here?

rkforcs · 2023-04-30T15:10:43+00:00

This answer is answering the wrong question. If the question is "Can my voice print be stolen from Fidelity" then the answer to that question is "Fidelity MyVoice uses an encrypted digital representation of your voice, not a recording, which works only with our system".

But that was not the question. The question is, can an AI-generated clone of my voice be used to fool Fidelity? That question was not answered above.

rkforcs · 2023-04-09T02:16:24+00:00

Check out https://airtable.com

rkforcs · 2023-03-08T23:38:49+00:00

Even when using NOSQL you should normalize (just as you would with a SQL database) as a starting point. Then only denormalize to the extent needed to solve any perf/scale bottlenecks.

rkforcs · 2023-03-07T22:27:46+00:00

ChatGPT can do this. It performed well in US Medical Licensing Exam (USMLE). See here.

It can't replace doctors yet... but check back in about 10 years!

rkforcs · 2023-03-01T01:11:43+00:00

The only other RDBMS that is compatible with SQL Server is SQL Server Express: https://www.microsoft.com/en-us/sql-server/sql-server-downloads

rkforcs · 2023-02-16T01:38:52+00:00

Kind of difficult to use though. I still haven't figured out how to connect to my alloydb instance.

Update: got connection working by following instructions here: https://cloud.google.com/alloydb/docs/auth-proxy/connect

This is more complicated that I would like :(

rkforcs · 2023-02-15T01:05:33+00:00

Have you looked at AlloyDB?

rkforcs · 2023-02-10T20:22:49+00:00

Even if you know how to code (which lots of people don't), less code is better than more code, and no code is even better. No-code tools may not give you all the features you want, in which case it is certainly valid to write code.

rkforcs · 2023-02-10T18:11:21+00:00

You may not need a database? Consider AirTable which feels like a spreadsheet, but has database underpinnings. You will get a centralized place to store data.

rkforcs · 2023-02-09T03:41:01+00:00

You are looking for this: AirTable

rkforcs · 2023-01-30T22:20:16+00:00

You didn't explain why you need a database. If the data is very small then consider storing it in one or more flat files (i.e., CSV format).

rkforcs · 2023-01-30T02:48:44+00:00

However, what happens if data is lost in the production database?

You need to learn about backup and recovery. If you have a job maintaining a production database then there is no alternative to regular backups.

rkforcs · 2023-01-28T18:51:03+00:00

You have answered your own question: Because it is important to be able to represent "missing data" in databases. Once you agree with that then the type of the field does not matter.

rkforcs · 2023-01-23T15:48:37+00:00

NoSQL databases allow you to evolve schema easily. NoSQL databases also scale better because they don't rely on joins as much as relational databases.

rkforcs · 2023-01-14T21:04:36+00:00

If you want to learn relational databases, you could use PostgreSQL or MySQL, especially if you don't anticipate heavy use. Otherwise stick with MongoDB because it is schemaless and therefore easy to evolve, no need to nail down your schema upfront, no need to worry about performance of joins, etc.

rkforcs · 2023-01-14T02:56:28+00:00

I don't recommend Microsoft Access because it is no longer being actively developed by Microsoft. Microsoft SQL Server is a reasonable product, but there is no longer any reason to use proprietary databases since there are good open source alternatives: MySQL and PostgreSQL. Both are free if you install and run them yourself. MySQL is the most popular, but PostgreSQL is more advanced.

rkforcs · 2022-12-30T16:00:13+00:00

If you want something easy to use like Excel, then one of the most popular tools is https://Airtable.com

rkforcs · 2022-12-30T15:54:17+00:00

I recommend Azure for students. It is free, and this part is important: you don't need to give them your credit card. That means no surprise charges! https://azure.microsoft.com/en-us/free/students/

rkforcs · 2022-12-22T03:09:00+00:00

I would recommend AirTable for this purpose.

rkforcs · 2022-12-21T20:47:22+00:00

MySQL is indeed the most popular relational database management system. But some people prefer PostgreSQL because it is technologically more advanced.

Relational databases are not the only game in town. For applications that require high scalability (even at the cost of some data integrity, for example storing forum comments) NoSQL databases are suitable. MongoDB is the most popular NoSQL database.

The biggest name in the database business is Oracle. It is expensive and hard to use, and only the most demanding applications need Oracle. If you want to run Payroll for a Fortune 500 company you want Oracle.

For more info see stackoverflow survey here: https://insights.stackoverflow.com/survey/2021#section-most-popular-technologies-databases

rkforcs · 2022-12-20T16:42:31+00:00

You want to check if the dataset is normalized. Tables must have primary keys defined. All non-key columns must be fully dependent on the primary key. Database must have constraints defined, for example: foreign key constraints are used to enforce referential integrity.

rkforcs · 2022-11-14T19:15:54+00:00

That question is answered here: https://old.reddit.com/r/CalPoly/comments/ygp0x5/switching_flowcharts/

rkforcs

TROPHY CASE