How does Google store search trends in backend?
Google trends shows what query has been searched how many times and some other properties of the said query. But how is this data stored in a database?
Should we have a database independent SQL like query language in Django?
Note :
Increase application performance [closed]
Closed 12 years ago.
DB Object passing between classes singleton, static or other?
So I’m designing a reporting system at work it’s my first project written OOP and I’m stuck on the design choice for the DB class.
Obviously I only want to create one instance of the DB class per-session/user and then pass it to each of the classes that need it. What I don’t know it what’s best practice for implementing this. Currently I have code like the following:-
How to handle monetary values in PHP and MySql?
I’ve inherited a huge pile of legacy code written in PHP on top of a MySQL database. The thing I noticed is that the application uses doubles
for storage and manipulation of data.
Is data integrity possible without normalization?
I am working on an application that requires the storage of location information such as city, state, zip code, latitude, and longitude. I would like to ensure:
Is data integrity possible without normalization?
I am working on an application that requires the storage of location information such as city, state, zip code, latitude, and longitude. I would like to ensure:
keeping connection open all time in sql
I have developed a Windows application in c# in which multiple users can add some numbers and their name and can view the data entered. The problem that I have is that the sever is on my laptop and every time I log off or close my laptop, they are losing connection to the DB and can not add or view any more.
how to model this relationship ? in ERD
I have three entities :
Do database tables need to have IDs?
Is an ID field is always needed in database tables?