Tagged Questions
13
votes
3answers
447 views
Good articles describing the infastructure of large commercial sites like Amazon.com?
Can anyone point me to a good primer on how a large scale commercial website like amazon.com is set up? Most importantly, I'd like to know about how the databases are set up. Do they have a ...
amazon
7
votes
9answers
313 views
High performance site
What technologies should I use when designing for a large social website (with a lot of transactions, like twitter)? using open source solutions
- database
- webserver
- os
6
votes
2answers
46 views
How can I Determine Date of Import from MySQL?
I uploaded a joomla website to my database some time ago. Now I would like to know what the exact date is that I uploaded the website. Is there a way to find this out in the database?
6
votes
10answers
749 views
Are there any existing solutions for creating a generic DNA sequence database with a website front end?
I'd like to create an rRNA sequence database with a web front end for the lab I work in. It seems common in biology to want to search a large number of sequences using alignment algorithms such as ...
5
votes
1answer
755 views
SQLite suitable for concurrent reading?
Will an SQLite database perform well to around 50 reads/second without locking?
I'm trying to decide whether it'd be feasible for use on a PHP website that won't get 'written' to very often - it'll ...
4
votes
13answers
4k views
What's the best way to store simple user settings in Python?
I'm programming (in Python) a website which will have users. These users will have a number of settings, such as their choice of colour scheme, etc. I'm happy to store these as plain text files, and ...
4
votes
3answers
473 views
Django - two projects using same database?
I'm working on my honor society's website, and I'm wondering if (1.) can two websites (Django projects) point to the same database, and (2.) if that's good practice.
Background info: Currently ...
3
votes
2answers
238 views
SQL Query only retrieving one row
I have a a php website with some code on it to pull from a database after the user has defined some search terms and then show them a table with all their information in it
The problem is even when i ...
3
votes
1answer
102 views
When is it a security risk to publish the database structure?
I'm planning a site which needs the users' trust. To help trust building, I was thinking to publish the source code, the database schema and even allow users to download raw data (so they can run ...
3
votes
3answers
331 views
Uploading Data to a Website from iOS Objective-C
I am a complete noob when it comes to iOS objective-c website connectivity. I need someone to point me to the right direction on how to upload/push data (i.e. a post) to the website that my friend ...
2
votes
9answers
1k views
Opening the database connection once or on every databaseaction?
Im currently creating a webportal with ASP.NET which relies heavily on database usage. Basically, every (well almost every :P ) GET query from any user will result in a query to the database from the ...
2
votes
3answers
39 views
what are the best ways to mitigate database i/o bottoleneck for large web sites?
For large web sites (traffic wise) that has alot of incoming reads and updates that end up being database I/Os, what're the best ways to mitigate the performance impact? one solution that I can think ...
2
votes
3answers
385 views
How a website should handle a database crash
I am currently creating a website in php that has a database backend (can be either MySQL or SQL Server) and I realized recently that if my database crashes at any time, my website will not run ...
2
votes
4answers
81 views
Good Database Solutions for small-medium Traffic Sites and Silverlight
What are some good database solutions that support Silverlight and are solid for a small-medium traffic website
Easy to use/Manage is a very strong plus
edit: Forgot to mention that the database ...
2
votes
4answers
637 views
Very very simple, secure database for static site
I have static website with a handful of pages for a bit of self-advertising. I'm wanting to put a small database online to store some clients details, preferably with the same layout as my current ...
