Tagged Questions
-2
votes
0answers
56 views
Server for running MySQL with ultra large databases? [closed]
I have quite many very large databases (millions of records at the least) in MySQL that need to be sorted, re-organized, indexed, etc. and I currently have 2 desktop Intel i7 PCs running all day long ...
1
vote
1answer
120 views
Which practice is the best for database connection? (PHP, etc)
Leave a open database connection throughout the execution of the aplication, or for each time a operation will be executed a new connection will be created?
Open throughout the execution:
Open ...
57
votes
13answers
4k views
Why use a database instead of just saving your data to disk?
Instead of a database I just serialize my data to JSON, saving and loading it to disk when necessary. All the data management is made on the program itself, which is faster AND easier than using SQL ...
-1
votes
1answer
267 views
How to develop a login/register system for Android? [closed]
How would it be possible to develop a login/register system for Android?
I have 0 experience with Android or general network programming but I do have a server running MySQL and anything else I may ...
-1
votes
1answer
85 views
Which database choose for my case? [closed]
I'm starting develop a new web application with PHP. This app will store GPS data from vehicles to trace their path. It's a monitoring tool. I'm predicting a large growth of data on it's database.
...
3
votes
5answers
220 views
Senior team members want to move query-relevant persistent data from DB to cache. Does this make sense?
I am a young engineer recently employed at a small company that sells products to the general public. We use Ruby On Rails and MySQL. Our database has a lot of customer data, but a great deal more of ...
2
votes
1answer
198 views
DB Schema for packaging products / services together under a single pric / Offer
I'm trying to 'conceive' the business logic of this website that have many activities, that the users can build their "combo" and get discounts depending on their choices and how long they are willing ...
3
votes
3answers
659 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 ...
0
votes
1answer
227 views
What schema documentation tools exist for PostgreSQL [closed]
MySQL has MySQL Workbench for designing and documenting your schema, and generates CREATE and ALTER scripts based on your design. We're looking at migrating to PostgreSQL in the near future, and we ...
1
vote
1answer
172 views
Sharing a database while we work on local copies?
A friend and me are working on a webapp. We're using git so each of us has a local copy of the app. But the problem is the database. We want to be able to see the latest changes the other person made. ...
1
vote
3answers
163 views
Help with DB Structure, vOD site
I have a video on demand style site that hosts series of videos under different modules. However with the way I have designed the database it is proving to be very slow. I have asked this question ...
6
votes
2answers
660 views
Making the switch from MySQL to PostgreSQL?
I've spent the last year becoming really comfortable with MySQL, but due to its increasing trendiness and my desire to homogenize my web-apps with Heroku, I'd like to start using PostgreSQL for my web ...
6
votes
3answers
177 views
What's the difference between the insert methods and why one is faster
I have insert 14.485 lines on MySQL like this:
INSERT INTO `bairros` (`id`,`cidade_id`,`descricao`) VALUES (1,8891,'VILA PELICIARI');
INSERT INTO `bairros` (`id`,`cidade_id`,`descricao`) VALUES ...
5
votes
6answers
1k views
Is there any reason to use varchar over text columns in a database?
Is varchar just a remnant from before text came around, or are there use cases where you would want to use a varchar? (Or char for that matter..)
(I use Postgres and MySQL (MyISAM) daily, so those ...
0
votes
2answers
116 views
How should I handle using two databases with a legacy PHP application?
I have a legacy PHP application that was written in 2004 and uses MSSQL as a database backend.
At this stage MSSQL is still supported by PHP but only just via a Microsoft driver. I have looked at ...
38
votes
12answers
9k views
Is it a bad practice to store large files (10 MB) in a database? [closed]
I am currently creating a web application that allows users to store and share files, 1 MB - 10 MB in size.
It seems to me that storing the files in a database will significantly slow down ...
1
vote
1answer
198 views
choosing Database and Its Design for Rails
I am having a difficulty in deciding the database & its structure.
Let us say the problem is like this.
For my product I have various customers( each is an educational institute)
Each customer ...
1
vote
1answer
141 views
Data base structure of a subscriber list
I am building a application that allow different user to store the subscriber information
To store the subscriber information , the user first create a list
For each list, there is a ListID.
...
1
vote
2answers
282 views
MySQL with mutiple threads and processes
I'm developing a telecom messaging platform in C, and I'm going to need multiple processes to be working with MySQL DB.
How can I make two processes read/write to/from a Mysql DB and, if/when one of ...
2
votes
7answers
1k views
What is the best approach for database design with lots of columns?
I am writing a query based financial application. It lets the user to write complicated equations (much like WHERE part of an SQL query) and find companies matching those criteria.
For the above, I ...
7
votes
5answers
3k views
Is MongoDB the right choice in my case?
I'm going to build my first real project in Rails that consist in a web app made of 3 main parts:
The static part where no database is used
The User registration part which will require a database ...
2
votes
1answer
138 views
How to swap out a DB from MySQL to SQL Server in a multiple large projects?
Is there a sane way / best practices way to swap out a DB from MySQL to SQL Server in a multiple large projects? Some of the projects are ASP projects, some of them are windows services, some are ...
7
votes
5answers
676 views
Is MySQL viable for small-medium business applications
After having worked with a Microsoft stack - VB.Net, ASP.Net, SQL Server - for the past 10 years, we are now faced with having to develop an application for both Windows and Mac environments.
It has ...
3
votes
1answer
207 views
Technique for multiple users on same datasets
This is more a learning question than coding, but I'm certain it's a common issue for anyone developing administration systems or applications in php/mysql/js etc.
I've developed quite a complex ...
0
votes
2answers
384 views
How to store personal information properly?
It's not about security or something. There is a table to record user information, like username, password, postcode and so on, one record per person. There is also a table called post to record the ...
1
vote
2answers
290 views
Database design
I'm on the way developing an application which requires a kind of dynamic database,
So this is what I want,
This is the for reading the details of a class, the number of variables and methods ...
5
votes
2answers
1k views
What's the difference between MariaDB and MySQL?
What's the difference between MariaDB and MySQL? I'm not very familiar with both. I'm primarily a front end developer for the most part.
Are they syntactically similar? Where do these two query ...
2
votes
5answers
497 views
Good techniques to speed up database execution
I have an ASP.Net application that is using a MySQL database. My queries are not executing as fast as I would like them too. Are there some standard ways to increase the speed of a MySQL database ...
6
votes
2answers
295 views
How should I organize the words of a sentence for better outputs/maintenance and performance?
Having this sentence (consider many sentences in the future)
David Henderson Houston patented the first roll film for cameras in
1881.
I can make questions like
1. Who patented the roll film?
...
5
votes
3answers
593 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 ...
