Tag Info

New answers tagged

-1

I would like to answer this in two approaches: 1. Non-Technical or General Approach 2. Technical Approach How about if I ask you this question ? How would you teach Logarithms to a student of 3rd Grade ?. He barely knows Addition, Subtraction and some simple Mathematical tricks. This can not be done in one day even if you put down entire list of ...


5

So if a thousand people are following Sally, we insert a thousand rows into the corresponding table. Is that scalable? Yes, provided the database tables are properly indexed. What happens if we get to the point where tens or hundreds of thousands of users are following Sally and she's making a few dozen posts per day? You'll generate a few dozen ...


-1

No,this is not race condition. Race condition means more than one user updating the value of same variable, and last assigned value will become the value for that variable. For example, if A assign value to variable X = 10, then B assign value to variable X = 12, then C assign value to variable X = 8, then 8 would became value for variable ...


-1

As a 20+ years programmer i am surprised HTML/php programming is so weak in how a user can use inspect element to change a value e.g product id before submitting. My solution is to use java script variables and only use HTML such as textboxes to inform the user of my intentions. eg declare variables in a global space i.e outside of a function. Example ...


-2

Well, for such a "complex" project, i suggest that you split up your domains into smaller pieces, call it modules. Maybe it is easier to work with apis/resources instead of direct queries to the database. Let me explain this a bit. Let's assume you want a front end part and a backend part. The front-end and the backend talks over an API, in my case a REST ...


1

Some options I would consider (not exclusive choices): use code that actually does an UPDATE when the record already exists. The user is updating the record so an UPDATE statement would match that better than manually deleting and re-insert which is fraught with danger and error-prone. use a temp table (with the same table structure) to store the ...


7

A bit about relational databases One of the most powerful features of relational databases is the ability to connect sets of data through common points. In order to do this efficiently, a database should follow the rules of normalization. To sum those rules up, a database should have: No repeating elements or groups of elements No partial dependencies on ...


3

A typical "MVC for the web" program might look something like this: RDBMS <--> ORM <--> DAL/SL <--> Controller <--> ViewModel <--> View RDBMS - Your database, usually something like SQL Server, Oracle or Postgresql. ORM - An Object-Relational Mapper, like Hibernate. The ORM converts tables to class objects, and vice versa. ...



Top 50 recent answers are included