Tagged Questions
4
votes
0answers
53 views
How can I best use a couple of days' intensive study to go the next level with MySQL?
I am at an intermediate level of skill in using SQL and have been able to get along at a basic level with SQLite, SQL Server, Postgres, and MySQL (the only exception is Oracle: "Q: How many Oracle ...
1
vote
1answer
76 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
102 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
110 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
286 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
894 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
70 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 ...
6
votes
5answers
270 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
129 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
140 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
175 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 ...
4
votes
2answers
383 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
386 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
180 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
322 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 ...
