• Activity
  • Votes
  • Comments
  • New
  • All activity
  • Showing only topics with the tag "databases". Back to normal view
    1. Data-at-Rest Encryption with MariaDB

      I've just spent the past eight hours reading about this and trying to implement it on my local machine (XAMPP for OS X). So far, I've been unsuccessful. Would anyone happen to know if Heroku or...

      I've just spent the past eight hours reading about this and trying to implement it on my local machine (XAMPP for OS X). So far, I've been unsuccessful.

      Would anyone happen to know if Heroku or another testing service could easily be set up like this?

      3 votes
    2. How to handle encrypted text fields?

      So, I have about fifteen years of web development experience mainly with classic ASP. Interestingly I never had a client who required any type of encryption other than some very low-level...

      So, I have about fifteen years of web development experience mainly with classic ASP. Interestingly I never had a client who required any type of encryption other than some very low-level username/password logins for administrative backends.

      What I am working on, as a pet project for my friends and family, is a private/direct messaging system that I will write with Go. To be clear, this is not a messaging service like WhatsApp nor Signal. It will be similar to the private/direct messaging that you see here at Tildes or Reddit.

      It is important to my friends and family that messages we write to each other be private and secure.

      Thus, how would I go about encrypting the messages so that if someone were to get into the server and acquire the database, they wouldn’t be able to read them?

      EDIT: At some point I will make the code available through GitLab.

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

      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
    4. How Do I Make A Database?

      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