• Activity
  • Votes
  • Comments
  • New
  • All activity
  • Showing only topics in ~tech with the tag "databases". Back to normal view / Search all groups
    1. Interpreting the Open Database License

      For reference, here is the ODbL. There is a nice human readable summary. You can also read more in the Wikipedia entry. The most famous database available under the ODbL is OpenStreetMaps. I...

      For reference, here is the ODbL. There is a nice human readable summary. You can also read more in the Wikipedia entry.

      The most famous database available under the ODbL is OpenStreetMaps.

      I recently found out about OpenCorporates, which is a global database of companies, published under the ODbL. I thought this was great, so I applied for access to use the database for a project. I was denied because I'm not a journalist or a nonprofit and instead was invited to pay for access instead. And it's not cheap, likely because company databases are often used in the B2B space.

      I replied that this seemed to be in conflict with their mission, especially given that my project was focused on using the data to create a benefit to the public, and their response was that they wanted to protect against their database being copied.

      From my reading, this seems to be in direct conflict with the ODbL. Egregiously so, which has me thinking I'm missing something.

      Does anyone have any insight? It seems to me that the whole point of the ODbL license is to make data freely available. This is backed up by interpretations I came across while searching and by the ethos of other orgs using the license, such as OSM. What am I missing?

      Edit: I'm still excited to hear from anyone with knowledge in this area, or just general insights into how I'm misunderstanding the license.

      And also, having learned that The Open Data Commons, which publishes and maintains the ODbL, uses this definition of the concept of open... I'm leaning towards the interpretation that OpenCorporates wants the aura of using a reputable license with the word "open" in it, but isn't genuinely interested in the ethos. Which is disappointing but not shocking, they'd be far from the first.

      10 votes
    2. How do I convince my workplace we need SQL databases?

      I work for a GIS company and our tools have not grown with our projects and client base. We use ArcPro personal geo databases (GDBs) for ALL data. We recently had a project where shit really hit...

      I work for a GIS company and our tools have not grown with our projects and client base. We use ArcPro personal geo databases (GDBs) for ALL data. We recently had a project where shit really hit the fan, one major issue was related to invalid values from poor version control. Everything uses personal GDBs and is just "version controlled" by dating filenames in Explorer. It would have been trivial to fix in a proper database. We also have operational constraints, like we can only have one person doing X job at a time since all the data for X job is in a personal GDB.

      But I'm just an analyst. I've garnered some attention for my technical expertise beyond processing the data. PostGIS is a thing so it isn't as though we'd be recreating the wheel. How can I push for that sort of change? I'm thinking I can sell it using how much we lost on this project because of these avoidable failures. I'm also wondering if I can make this an opportunity to create a "database administrator" position for myself

      29 votes
    3. Slowly starting a passion project of a finance web-app that I can use help me budget but I have a crucial question

      I am planning to use Plaid API and have a spring boot backend but given that I will be storing my financial information (such as whatever the Plaid API needs me to store to use their endpoints as...

      I am planning to use Plaid API and have a spring boot backend but given that I will be storing my financial information (such as whatever the Plaid API needs me to store to use their endpoints as well as just the transactions on my credit and chequing account), the security of the data is obviously crucial. and I think my problem is I don't know what I don't know.

      I have a basic idea of what kind of things I need to protect against.

      1. WIll have to use Spring security (or whatever is best) for thing like protecting against xss and csrf
      2. I need to ensure that the PostgreSQL database is encrypted

      but beyond that, I don't know much about the nuances of each type of security and customizations I should be on the look-out for. wonder if there's a trustworthy resource for at least detailing for me the kind of security I need to implement on either the Spring or PostgreSQL side of things?

      11 votes
    4. NewsBlur Mongo database deleted in ransom attack (and restored)

      NewsBlur was down yesterday evening due to its Mongo database getting attacked by a hacker and held for ransom. It’s restored from backup, but there are privacy implications for anyone who had...

      NewsBlur was down yesterday evening due to its Mongo database getting attacked by a hacker and held for ransom. It’s restored from backup, but there are privacy implications for anyone who had sensitive private data there. We will likely find out more after the maintainer recovers from a busy night.

      There are no good links for this, but it’s being discussed on Hacker News. Since it’s open source, someone described what’s being kept in that database.

      (I use NewsBlur, but I don’t think my RSS reading habits are all that sensitive. Others might be in a different situation, though.)

      6 votes