Best Databases to Use

SQL Databases

• PostgreSQL:

  • Pros: Simple and solid, good developer experience, battle tested.
  • Cons: Some users may find it complex to set up.
  • User Quote: "I would probably use postgres or even SQLite since they're simple and solid."

• SQLite:

  • Pros: Lightweight and easy to use.
  • Cons: Limited scalability compared to other databases.
  • User Quote: "I use SQLite... Because in Prisma, JSON is not supported in SQLite."

NoSQL Databases

• MongoDB:
  • Pros: Extremely fast and fault tolerant.
  • Cons: Some users find it worse in almost every scenario.
  • User Quote: "I would recommend noSQL database such as MongoDB its extremely fast."

Other Recommendations

• Supabase:

  • Pros: Works well with NextJS, Postgres with easy management and nice GUI.
  • Cons: Limited information on cons provided.
  • User Quote: "I use Supabase and MongoDB. Both work perfectly with Nextjs."

• Neon:

  • Pros: Great branching features, delightful experience.
  • Cons: Limited information on cons provided.
  • User Quote: "I've really been enjoying Neon."

• MySQL:

  • Pros: User-friendly for beginners, widely used.
  • Cons: Limited scalability compared to other options, may have limitations for advanced users.
  • User Quote: "I was using the Google Sheets API, but see no advantage... trying to decide from these three: PostgreSQL, MongoDB, MySQL."

• Google Sheets:

  • Pros: Ease of use.
  • Cons: Limited capabilities compared to dedicated databases.
  • User Quote: "I was using the Google Sheets API, but see no advantage..."

General Advice

• Consider learning more about databases if unfamiliar with them, such as through online courses.
• Evaluate the specific needs of your project to determine the most suitable database.
• Consider the scalability, ease of use, and features offered by different databases before making a decision.