Tag Info

New answers tagged

2

Create a table which will store information about notifications: TABLE notifications event_id user_id datetime // date and time when notification must be sent Every time someone joins some event, you should insert a new row in the notifications table. To notify users, you need script which will perform a mysql query like: SELECT * FROM ...


1

Your first option -- write something to convert it into normal DB data -- is the right way to go here for a few reasons. It makes development easier as you have a clean demarcation of roles and you can get a functioning data processing app on one hand and test the front-end against test data on the other hand. This code can be in C# and can even be in the ...


2

This sounds a bit unwieldy as a solution, but the simplest answer to your question is add another column called "project" and make it part of the primary key along with id: then every time you create a new project insert another 200 rows (shudder) with id's 1 to 200 and the new project id or name or whatever, and... yeah. It'll achieve what you want, but.. ...


1

Some considerations: Choice of database: relational databases such as Mysql or Postgres are not necessarily harder to scale than MongoDB and such. In many cases it's quite the opposite. Here is a great comparison of different storage technologies: http://kkovacs.eu/cassandra-vs-mongodb-vs-couchdb-vs-redis "Event-driven" architecture: You have a lot of ...


1

This is the classic single-tenant vs multi-tenant dilemma. To service multiple clients, should you: Have a single database that includes the data for all your clients (i.e. make them all tenants of your single database), or Have multiple databases, with each client partitioned off and the single tenant interacting with just its own database. Most of the ...


-1

Do you need a separate step? It's often faster to read each line, clean it and insert it into your CMS. If you have a lot of cleaning and processing, you might want to look at kettle from pentaho, it handle Extraction, Transformation, and Loading (ETL) and could help you (beware, takes a while to master)



Top 50 recent answers are included