• Activity
  • Votes
  • Comments
  • New
  • All activity
    • Showing only topics with the tag "databases". Back to normal view

    16. What are the main considerations/downsides to make before adding an index to a column

      ~comp Text 78 words
      I was asked this question in an interview and I said the downsides would be extra disk space used to store it and more disk writes from the database to maintain the index on updates. I asked a...

      I was asked this question in an interview and I said the downsides would be extra disk space used to store it and more disk writes from the database to maintain the index on updates. I asked a friend and he said the downsides are space used in memory to store the index as well as the fact that an index could take days to build on a large dataset.

      What does everyone here think about this question?

      8 votes

    24. How Do I Make A Database?

      ~comp Ask
      Hello everyone! I've recently got an idea for a Database as a Service I'd like to create. The only issue is - I don't know how to create or host a database! I've only ever used Mongoose/mLab with...

      Hello everyone!

      I've recently got an idea for a Database as a Service I'd like to create. The only issue is - I don't know how to create or host a database!

      I've only ever used Mongoose/mLab with Javascript, and a minimal amount of Postgres with Python.

      If I'm looking to create a database that will, eventually, be able to store images, songs, and videos, where should I start my homework?

      I can create the backend and the frontend with no issue - just stuck on this part here. If it's of any relevance, I most frequently use the MERN stack.

      13 votes