0
votes
1answer
40 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
115 views

Advantages and disadvantages of making one DB per customer [duplicate]

I'm starting to design a web application, and I'm evaluating some decisions regarding the general structure of it. My use case is as follows: I plan to have multiple customers on a single server. ...
3
votes
1answer
155 views

implementing dynamic query handler on historical data

EDIT : Refined question to focus on the core issue Context: I have historical data about property (house) sales collected from various sources in a centralized/cloud data source (assume info ...
1
vote
3answers
219 views

Why is my page load time so closely correlated with number of database queries?

Whenever I'm doing web development, and a page takes longer than half a second to be generated, I know that somewhere my code is hitting the DB too many times. The normal way to fix this situation is ...
2
votes
3answers
184 views

How does database connection pooling improve application performance?

I can't understand why connection pooling improves application performance. I suppose connection establishment would cause latency. But reusing an established connection requires more complex error ...
-1
votes
1answer
155 views

Intranet application platform decisions wamp vs node [closed]

I have a client/server java application with a firebirdsql backend. This is a pain because I have to install java and the client on every workstation, etc So it is now time to rewrite the ...
1
vote
1answer
207 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 ...
1
vote
2answers
1k views

Storing large data in HTTP Session (Java Application)

I am asking this question in continuation with http-session-or-database-approach. I am planning to follow this approach. When user add product to cart, create a Cart Model, add items to cart and ...
1
vote
2answers
118 views

Configurable tables in sql database

I have the following tables in my database: Config Table: ====================================== Start_Range | End Range | Config_id 10 | 15 | 1 ...
1
vote
3answers
218 views

How do the blogging sites or sites that host prose like contents store the data? [closed]

How do the blogging sites, Q&A sites (or any other sites host prose like content) store their data? That is, how do you store blogs and Q&A content in the database? I hope it is not good to ...
0
votes
2answers
187 views

Best practices for rotating large datasets?

[edit]Turns out there's 1.5 million records... The SQL database is taking about 17-20 seconds to run the query. Would it be best to have Java handle the joins and rearranging in that case? Since this ...
11
votes
2answers
1k views

General thought process for “How would you build this website/app” interview questions

I've collected a bunch of interview questions like "Describe how you would design a photo album application", "Describe how you would design this particular feature of this particular website" (e.g. ...
7
votes
6answers
3k views

HTTP Session or Database approach

I am confused a little as what should be my approach, Working on a design of shopping cart and i need to store shopping cart either in session or in database but not sure which approach would be ...
4
votes
5answers
974 views

Suggested Web Application Framework and Database for Enterprise, “Big-Data” App?

I have a web application that I have been developing for a small group within my company over the past few years, using Pipeline Pilot (plus jQuery and Python scripting) for web development and ...
0
votes
6answers
325 views

For a web-application, should I programmatically create the database tables or provide a schema file and instructions?

The few LAMP web applications I have installed require me to create the necessary database tables myself, with a schema file, instead of doing it automatically with a script or setup page. Is this a ...
0
votes
2answers
547 views

Designing a Web Application with Two Different Backend Databases [closed]

I'm working on a pretty standard LAMP based web application. The server itself has a standard MySQL database and the application is written in PHP. The kicker is, we also use SQL Server databases ...
1
vote
3answers
504 views

Looking to create website that can have custom GUI and database per user [closed]

I have developed an MS Access database for a company to track data in regards to production of a certain commodity. It has many many tables, forms, reports, etc. These were all done as the user ...
2
votes
2answers
197 views

Saving all hits to a web app

Are there standard approaches to persisting data for every hit that a web app receives? This would be for analytics purposes (as a better alternative to log mining down the road). Seems like Redis ...
2
votes
1answer
129 views

One codebase - lots of hosted services (similar to a basecamp style service) - planning structure

We have built a service (PHP Based) for a client, and are now looking to offer it to other clients as a hosted service. For this example, think of it like a hosted forum service, where a client signs ...
0
votes
2answers
146 views

starting project with growth in mind. [closed]

I have an idea for a web application and have some good people keen to get involved. I will be doing most of the code at the start and have a few years experience with some quite large projects. I ...
3
votes
3answers
4k views

How best to store images on a file system

Developing an application in which users have to upload images. I have not really got much experience with file uploads in an application so I am wondering what the best way is for storing images ...
13
votes
5answers
1k views

Is it the job of programmers to design the database?

I've been a programmer for the past six years. Throughout my career, I have worked on many web applications. Most of the time, when a database was needed, it was given to us (the programmers) or we ...
1
vote
5answers
488 views

Why is it evil to run selects from a prod server?

I'm basically looking for arguments to persuade the internal "consultants" at work as the following are not working: What happens if you do a Cartesian join and crash the server? You don't need to ...
0
votes
2answers
1k views

What are the pros and cons of storing files in DB2 vs folders? [duplicate]

I work in a Web Application where users are allowed to upload files. They can retrieve and view those files at a later point in time. A solution that user works with can have multiple attachments but ...
28
votes
4answers
16k views

Difference between REST and CRUD

I learned REST and it feels a lot like CRUD (from what I have read about CRUD). I know they are different, and I wonder if thinking they are similar means I don't understand them. Is it that REST is ...
3
votes
3answers
225 views

What is an efficient way to retrieve product counts at multiple levels of a hierarchy?

I'm working on an e-business website to sell books and also want to display the number of available books in the category list. The category list contains the genre and the format (pocket, ebook, ...
3
votes
2answers
264 views

Which database paradigm is suggested for a site with search capabilities?

Currently I'm trying to select the best DB paradigm to implement a web site with full-text search and faceted search capabilities. I have an important functional requirement: The database paradigm ...
2
votes
2answers
223 views

Duplication of view access control logic in database queries and application component

Our web application has a complex access control system which incorporates role-based and object-level privileges. In the business logic layer, this is implemented by a component that obtains (and ...
8
votes
5answers
2k views

Writing Web “server less” applications

TL;DR What are the prospects of writing applications which are completely based on a REST database server (CouchDB) and web applications which directly access the DB instead of having a web server in ...
4
votes
1answer
454 views

Scala - learning by doing

coming from the PHP-framework symfony (with Apache/MySQL) I would like to dive into the Scala programming language. I already followed a few tutorials and had a look at Lift and Play. Java isn't a ...
5
votes
3answers
498 views

How do I determine which language/framework is best for our web-based project?

I'm in the early stages of development for a web application that has three developers (myself included) working on it. The project is, at its core, a web-based database that will be used by around ...
-1
votes
4answers
813 views

How to obtain GPS Coordinates for local businesses? [closed]

Is anybody aware of a database that consists of businesses, addresses and GPS location information, preferably searchable by city at a minimum? I have an application in mind that I'd like to develop ...