Menu
I’m in the process of setting up a CKAN instance. I have to setup a postgres database for CKAN to be operated. Additionally I have to set up a dataStore too.
I found this question on stackoverflow but didn’t answer my question.
How to think in data stores instead of databases?
In general what’s the difference between a dataStore and a database?
838
Datastore is a NoSQL document database built for automatic scaling, high performance, and ease of application development. Datastore features include: Atomic transactions. Datastore can execute a set of operations where either all succeed, or none occur.
Like databases, cloud data warehouses deal with data; the difference is that instead of transactional processing the end-goal with any data warehouse is end-to-end analytics. Cloud data warehouses consolidate data from multiple sources making it accessible for analysis.
First, AWS data-storage services are grouped into two main service groups: AWS storage and AWS database. Generally, the services grouped under storage are more open-ended, while database services focus specifically on managing database software and storage.
At Shopify, we use MySQL as our RDBMS. MySQL is durable, resilient, and persistent. We trust MySQL to store our data and never, ever lose it.
CKAN uses two PostgreSQL databases:
CKAN's catalogue database, this is the first database that you're asked to configure when installing CKAN. This stores all the data for CKAN's data catalogue, e.g. the metadata associated with datasets and resources (titles, tags, etc.), the user accounts, the groups and organizations, etc. etc.
CKAN's DataStore is an optional feature that enables a Data API and data previews for files uploaded to or linked to from CKAN. This is a second PostgresSQL database, data*store* is just the name the CKAN uses for this feature. (The DataStore in CKAN has nothing to do with the Google App Engine concept of data store that you linked to.)
CKAN also has a FileStore which, if enabled, is used to store files uploaded to CKAN. The FileStore isn't really a database, it's just a directory on disk that stores uploaded files.
113
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
