Tag Info

New answers tagged


There are many node libraries specially made for this. You could try ORM solutions like SequelizeJS http://sequelizejs.com/ or in your case I think Knex http://knexjs.org/ would be better.


For starters, at this scale, you cannot brute force it. Let's say it takes 1ms to both compute and store in an ordered list the relatedness of one tag for a given article (that seems generous on your average machine). You have to do this 500,000,000,000,000 times. Or 500,000,000,000 seconds of work, which is equal to longer than recorded human history. ...


Initial response Some preliminary matters: As a practical matter I find it's helpful to throw in date fields for created/modified times; it makes your life much easier when debugging data problems. Pretty much any table that's not a lookup table would benefit from it. If a table is write-once, consider foregoing the modified time column. Be sure that ...


Keep the db writes async, so when user sends gps or anything else, make a thread safe POJO with all the details, set it to a class that implements Runnable and put it in to a queue. Natural question is what happens if server fails? Question from me is : how important is that? If a few 100 inserts fails will the users lose money? Stop using the app? if no ...


First about storing file paths: Having several image path columns (imagepath1, imagepath2 ... imagepathN ) violates 1NF. Storing several comma-separated image paths in the same column also violates 1NF. When you violate the simplest of normal forms, you will have a lot of headaches in the future. The correct thing to do is create a separate table for ...


Are you using a connection pool? very often I have seen developers using an application server without a connection pool and the majority of the time is spent establishing DB connections which are very heavy processes. Apart from that using a profiler like jprofiler (for which you can get an eval license) would be your best port of call to diagnose your ...


Create another table with a schema similar to userid PrivacyTypeId allowed and PrivacyTypeId PrivacyType This structure will allow you to add\remove\deactivate permissions without any DDL changes

Top 50 recent answers are included