MySQL is an open-source, relational database management system.
-1
votes
1answer
49 views
write my own or choose a framework for link sharing website [closed]
I'm a PHP programmer and I've done any projects based on PHP and MySQL without using any framework so far.
Now I'm going to create a big link sharing system (excel-able,modular,fast,theme ...
0
votes
1answer
97 views
Webservice like jsfiddle for php & mysql [closed]
Jsfiddle is great service for html,css,javascript, but sometimes I need to check idea for php,mysql. Can you recommend any service like this? (There is of course http://ideone.com/ , but limited to ...
-4
votes
0answers
52 views
Programming a survey [closed]
I need to make an application that collect data as a survey then do some calculation on them .
Do you think php/mysql is best suited for this task ? or there's an easier way to do it ?
Thanks in ...
-4
votes
0answers
60 views
What language / technologies are best suited for a survey? [closed]
My goal is to create an application that acquires some data , do some calculations on them then display some results .
I'm having a difficulty related on which language or technology I should use to ...
0
votes
1answer
104 views
How does MySQL blob actually work?
This is a question driven by curiosity. I am learning Oracle database and Oracle database handles Blob data in a separate tablespace, which I believe reduces overhead while trying to read large Blob ...
0
votes
0answers
28 views
Requesting advice with Laravel for a “configurator” app
I got a new project that is developed with Laravel. It is a kind of "configurator" webapp to build a vehicle. When the user arrives on the page, (s)he selects a chassis type, then accessories can be ...
0
votes
1answer
60 views
Running entire frontend of a system on a flatfile cache
I'm in the middle of moving away from PyroCMS to a custom solution built on Laravel. Wont go into the details as to why here, but it is a necessity.
I'm toying with the idea of caching things like ...
0
votes
0answers
8 views
jdbc error java class trying to connect to linux mysql server [migrated]
My error!
DBConnection2.java:38: unreported exception java.lang.InstantiationException; must be caught or declared to be thrown
Class.forName("com.mysql.jdbc.Driver").newInstance();
problem: ...
3
votes
7answers
329 views
OOP (php) for beginners - some unclarities
I started reading some tutorials about OOP, because I want to learn the basics.
I have a question about it. I understand how you can have a object "Car" and give it a color like this ...
-1
votes
0answers
41 views
Python: Single Quotes Showing up in my Database [migrated]
I'm doing some python programming, inserting data into a MYSQL database for a project. I've been doing the coding, but noticed an odd artifact; Whenever I insert string data, my database includes the ...
0
votes
0answers
3 views
Count two columns and show total where criteria met [migrated]
I have seen this question asked and answered here and elsewhere and still cannot get the result I want. So, please excuse the duplication.
I want to return a table that shows how many times a player ...
-2
votes
0answers
63 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
150 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 ...
1
vote
1answer
101 views
Class table inheritance… To 'type' or not to 'type'
I currently have a database that uses Class table inheritance model. Three different tables inherit from this table. The child tables have all a FK to the parent table and the fields are properly ...
0
votes
2answers
344 views
Argument with my Developer [closed]
I'm a designer who can code, so I'm getting an app developed from a professional PHP developer using CodeIgniter Framework. Although I trust him very much, but lately we had an argument on a couple of ...
1
vote
2answers
281 views
PHP frameworks for social network?. Cons and Pros? Flexibility and Modification offered? [closed]
I am a newbie to PHP. I just learnt PHP and MySql from a book working my way through syntax and example codes. Right now I am good at syntax and I can write my own simple scripts.
I was thinking of ...
0
votes
0answers
35 views
Does ejabberd datastore allow customization of message archiving?
I'm developing a chat-based app on iOS. There is some gameplay associated with the chat, so I need some control of how messages are stored - I either need to embed some tags within the messages or ...
-1
votes
1answer
64 views
MySQL for application developers [closed]
I am an application developer and we plan to use MySQL.
My question is what would be the best book to familiarize with this specific database for a non-dba person?
I am not looking for a book on SQL. ...
2
votes
2answers
360 views
Why OTServs have an item cloning problem if the server crashes? [closed]
OTServs are open source MMORPGs with a huge community. Mostly all of them have a serious problem: if the server crashes, people can clone items. This is a dirty trick that can be executed because the ...
0
votes
1answer
149 views
run local php/database application on windows pc without wamp
I have a php/mysql applications which I designed, and the client doesn't want it to be online (installed on a webserver) or available on the internet, he wants his employees to use it on a local ...
-1
votes
1answer
108 views
What are techniques used to make scalable, fast databases? [duplicate]
I'm studying the differences between NoSQL and SQL. If I understood correctly, there are two main techniques to optimize a database:
Indexing rows. Say you wanted to make a query such as WHERE x = 1 ...
1
vote
1answer
220 views
Is map-reduce the basic factor that makes NoSQL more scalable than SQL?
I'm studying the differences between NoSQL and SQL, and what makes the first more scalable. I think I got the point, so I'll try to explain:
Suppose an app has a list of billions of users, each with ...
88
votes
12answers
29k 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
305 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 ...
2
votes
1answer
126 views
Sorting rows off an autoincrementing primary key
Is it a bad practice to rely on an auto-incrementing primary key to sort rows in a table? A coworker and I were having an argument about this subject. We need to be able to find the last-inserted row ...
-1
votes
2answers
192 views
Store and trigger cron-'like' actions with PHP and (My)SQL [closed]
I'm crashing my head over a design decision, and I'm trying to get some more inspiration/hints/tips/.. from other programmers.
What is the goal:
I want to run one cron task (php script) every ...
-1
votes
1answer
88 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
2answers
337 views
I need advice developing a sensitive data transfer/storage/encryption system
I got closed on SO and told to post this here as it's about general application design as opposed to specific code.
Intro
I'm currently working on a project which involves the daily extraction of ...
3
votes
5answers
225 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 ...
5
votes
4answers
284 views
QR Codes as Booking Confirmations for Conference?
A client of mine is holding a conference and we have the task of creating a booking system for them. However they have requested that we use QR codes so that on the door, a person can simply present ...
3
votes
1answer
50 views
MySQL setup for remote site failover
I'm designing a custom web-based inventory management and workflow system for a client of mine. One of their remote sites has fairly sketchy internet access, and needs to have no (or very little) ...
1
vote
3answers
226 views
Should I calculate hotness of a post on request or pre-calculate it?
Here is the Reddit's hot algorithm:
cpdef double _hot(long ups, long downs, double date):
"""The hot formula. Should match the equivalent function in postgres."""
s = score(ups, downs)
...
0
votes
1answer
170 views
Retrieving hierarchy of tree-nodes stored in relational database
I have a hierarchical ADT that I want to store in a database.
Nodes have exactly one parent element that is a node as well. Multiple nodes can have the same parent node.
My current approach uses an ...
15
votes
3answers
613 views
How to design website workflow?
I have been thinking about this for really long time without reaching an optimum answer.
First of all, I'm a medical doctor who loves programming but never really studied it, except for home learning ...
4
votes
1answer
235 views
Multi-platform design with Delphi, Java, MySQL and CouchDB
What are the most obvious drawbacks to this idea for an enterprise(ish) model using the following technologies.
Browser based and native developed GUI using Delphi to connect to
Datasnap server ...
2
votes
1answer
205 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 ...
-1
votes
1answer
119 views
Web App architectural design, help me stop buying more servers to scale up! [closed]
Background: I am part of a small dev team, I am not the lead\senior developer. The lead developer is very knowledgable and I trust his decision making but I am starting to wonder if we could improve.
...
1
vote
2answers
182 views
How do I add restrictions for users to sign up before they can access web site?
How do I get my webpage not to go back when they hit the back button and are logged out ?
how can I add a web page to be blocked like FACEBOOK doesn't let you get into their site with out having a ...
3
votes
3answers
376 views
Is it conceivable to have millions of lists of data in memory in Python?
I have over the last 30 days been developing a Python application that utilizes a MySQL database of information (specifically about Norwegian addresses) to perform address validation and correction. ...
3
votes
5answers
265 views
When do I bite the bullet and hire a developer? [closed]
I have an awesome URL, I've had it since the mid 90's, and up until around 2002 I was having an awesome time writing music reviews and features into static pages and adding their URL to static index ...
1
vote
6answers
897 views
Should I encrypt data in database?
I have a client, for which I'm going to do an Web application about patient care, managing patients, consults, history, calendars, everything about that basically.
The problem is that this is ...
0
votes
0answers
42 views
Moving sql database [closed]
I need to move the sql database to a new server without changing the app that uses that database, how can i do this easily without affecting the users ?
0
votes
2answers
438 views
What is appropriate way for managing MySQL connection through C#
My question, at the bottom line, is what is the appropriate(best) way to manage our connection towards MySQL db with C#.
Well, currently I'm working on some C# (winforms type) <-> MySQL ...
1
vote
5answers
359 views
Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
I want to link several tables to a many-to-many(m2m) table.
One table would be called location and this table would always be on one side of the m2m table.
But I will have a list of several tables ...
3
votes
3answers
688 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
250 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 ...
3
votes
1answer
191 views
Having a generic data type for a database table column, is it “good” practice?
I'm working on a PHP project where some object (class member) may contain different data type. For example :
class Property {
private $_id; // (PK)
private $_ref_id; // the object ...
1
vote
1answer
174 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. ...
2
votes
4answers
585 views
Is it possible to keep only one Database for both web and desktop applications?
I'm experiencing a trouble with my business model, let me explain better.
I'm developing a software for 1 year and few months, it's for the food industry, more exactly a software to: Delivery, Take ...
0
votes
1answer
421 views
How to check for null in most sql's - “column is null” or “column = null” [closed]
I'm not sure of the right syntax to use.
Is it
select * from tlb
where flag is NULL
or
select * from tlb
where flag = NULL
Is the answer the same for oracle, sqlserver and Postgres?
