Tagged Questions
2
votes
2answers
735 views
Database model for keeping track of likes/shares/comments on blog posts over time
My goal is to keep track of the popular posts on different blog sites based on social network activity at any given time. The goal is not to simply get the most popular now, but instead find posts ...
3
votes
1answer
129 views
Good way to handle the notification counter like Facebook does
I want to build a similar notification mechanism that Facebook handles.
I actually store the user's notification in an SQL table (actually it's a graph database but everybody master RDBMS terms).
...
0
votes
1answer
41 views
Using different DB Connections for different user groups in a web framework
Database designers building enterprise systems usually assign different sets of privileges to different users of DBMS. They can be as granular as needed.
However, in my experience, web frameworks ...
1
vote
1answer
139 views
Processing csv files (alternative to business logic in DB)
We are working on a fulfillment system for an online book store. Everyday we receive tens of CSV files (about 90 files) with data about purchased orders.
Example:
OrderId | BookTitle | ...
0
votes
3answers
551 views
Unique and primary keys on a database (mysql)
I'm having quite some doubts here... If I have a table related to username/password login how can I assure there won't be any more matches of the same username and password in the same table using ...
0
votes
0answers
65 views
Creating A News Feed with Relevant Data for App
I'm creating an app that currently allows users to create topics, vote in topics, follow topics, and chat in topics.
Currently working on creating a News Feed like Facebook or Twitter that brings ...
5
votes
7answers
822 views
Server-side event logs through DB or writing to file?
I am developing a web application as well as the API the web application uses. I'm trying to determine whether it is better to log events (to determine the path that leads to an error as well as to ...
1
vote
1answer
211 views
Complex knowledge management system with CRM..written internally
We've all heard of salesforce and sugarcrm and the likes of systems like this.
Unfortunately at my workplace we have been asked to write a similiar system (rather then license or purchase). Basically ...
3
votes
4answers
761 views
What's the best way to cache a growing database table for html generation?
I've got a database table which will grow in size by about 5000 rows a hour. For a key that I would be querying by, the query will grow in size by about 1 row every hour. I would like a web page to ...
2
votes
3answers
179 views
How long should I wait to autosave user input?
I have a table where a User can edit data by simply choose a field, then edit its value. I want to fire an update function to automatically save the data to a MySQL database.
However, I think that ...
10
votes
3answers
892 views
How do you put a database online? [closed]
I have a very beginner question regarding web development.
I've had some experience with JSP, Hibernate, and MAMP to create a simple system for tracking inventory and sales. But this was all done ...
1
vote
1answer
169 views
How should I handle two crons that update the database?
I'm working on a Bitcoin-clone block explorer (specifically Mincoin) which has a block timer of about 1 minute. For those unfamiliar with Bitcoin, basically a new data structure called a block is ...
11
votes
3answers
1k views
How to create better OO code in a relational database driven application where the database is poorly designed
I am writing a Java web application that consists mainly of a bunch of similar pages in which every page has several tables and a filter that applies to those tables. The data on these tables comes ...
1
vote
1answer
104 views
Are there any standard for exchanging rules rather than data?
Just out of curiosity. There are many open standards for data exchange, as well as standards for exchanging code (jsonp, for example).
But are there any standards for exchanging formulas/rules, for ...
3
votes
1answer
183 views
Database Schema for Pricing Products (packages, promotions, qty based, limited time offer…)
I'm working on a new point of sale for a company that products for different prices depending on the product mix.
All products have a base price.
To explain my problem, I will use the following ...
0
votes
2answers
401 views
Python/Database Website development [closed]
I want to create my own website that would allow me to acess a database in the server and do inserts and lookups in a user friendly way. I am a seasoned user of linux and C/C++, and also have ...
1
vote
2answers
312 views
JSON vs Foreign Keys
I'm developing an enterprise website, and I have to define some sections like this:
I have many sections and each section have many (or one) sub-pages.
The number of sub-pages vary per section.
...
-2
votes
2answers
3k views
Data Grid for Web Application [closed]
Are there any good Data Grid libraries that allow the user to view and edit data from a database?
My boss asked me to research possible Data Grid resources to supplement our web application and I ...
4
votes
2answers
304 views
Do I really want a dynamic Enum, or something else? Better caching? A Struct?
This question is asked on SO and this site often it looks like. "How do I do a dynamic enum?" Answers range from you shouldn't to possible compile time solutions. Now my question is do I want a ...
6
votes
1answer
223 views
What is “the right way” to do search on a website?
I'm talking the kind of search that auto-suggests your query as you type, the way Google does, the way Wikipedia does, the way Stack Exchange suggests other questions as you type the title, etc. And ...
4
votes
3answers
3k views
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.
Now I came across ...
5
votes
2answers
379 views
GIS-based data visualization and maintenance tool
Background
Looking to leverage an existing GIS system for exploring organizational data.
Architecture
The following figure represents a high-level overview of the system's desired features:
The ...
3
votes
2answers
185 views
Taking a Projects Development to the Next Level
I have been looking for some advice for a while on how to handle a project I am working on, but to no avail. I am pretty much on my fourth iteration of improving an "application" I am working on; the ...
3
votes
4answers
371 views
How to implement a system to hide spammed user content?
I'm trying to work out a good way to manage user submitted content and create a method to determine when spammed/poor content should be hidden.
The aim is to create comment voting similar to youtubes ...
4
votes
2answers
802 views
Making sure database connection information is secured
This is the first time that I am working on a web application. I was going through the question What should every programmer know about web development? and noticed one thing that I knew nothing of:
...
2
votes
1answer
295 views
Calculate statistics for web application
I'm planning to add a couple of usage statistics to my web application. Some common things like: registered users, amount of comments/posts, etc. over time (last 24 hours / last week / last month / ...
0
votes
1answer
156 views
Which technology stack to use for car pooling over web and mobile
I want to start working on a project where I want to build a intranet website and mobile app for people working in my office for car pooling. The basic idea is that if anyone is interested in looking ...
7
votes
3answers
1k views
what are the best tips for storing images in a database?
Is it appropriate to store the image files in the database? Or it would be better to store only the path of the file in the database, while keeping the file itself on the server?
Are there any other ...
7
votes
2answers
951 views
Can map-reduce say “Hello World”?
Gathering that map-reduce is being used to process huge amounts of data, I set out to understand it.
My queries were:
What class of problems does it aim to solve?
How does it help breaking down of ...
6
votes
3answers
2k views
Unit testing vs Integration Testing [duplicate]
What is the difference between unit testing and integration testing when it come to web development (where 90-95% of the code relies on a database)? One thing I here all the time is that unit testing ...
15
votes
5answers
1k views
Databases and Unit/Integration Testing
I have had a discussion with someone about unit/integration testing with web applications and I have a disagreement about 1 core idea. The issues is that the person I am talking to think that the ...
1
vote
1answer
377 views
difference between Visual Studio and RADs?
What is the main difference between a Rapid Application Development tool like MonoDev and Visual Studio, is an RAD more focused on one thing? I'm looking to make a web application, are there ...
0
votes
1answer
71 views
What things should be considered in the license etc when you're using some open source projects/ tools in your application
What things should be considered in the license etc when you're using some open source projects/ tools in your application(in my case, specifically a web application/website) ?
What are the ...
4
votes
3answers
406 views
Does the programming language or database you use have any effect on the selling of your site?
I was just wondering if the programming language or database you use has any effect on selling your site to another company? I mean is it easier to sell PHP site than other language? How about ...
8
votes
6answers
822 views
Learn a NoSQL or become a badass with traditional RDMS - Where is/will the work be? [closed]
New Question Version:
I've got the opportunity to spend 3 months getting good at something, its going to be either a NoSQL technology like Cassandra or optimising relational database systems. I ...