I'm looking into building a large-scale J2EE application that really doesn't have much more functionality than storing/retrieving data and then formatting it either to the user interface, a predefined "form", or to XML based webservices. There might evolve into a need for relatively complex relationships in the future though. So my que...
I understand the obvious answer to my question is: "it depends". With that out of the way, I'm hoping one (or more) of you will help me see common ways to approach this... I'm designing a database of widgets for sale. Over time the prices for each item will inevitably change. My question is should we be tracking these changes and if so,...
I want to create a simple CMS with PHP and MySql, I use wamp as a server. Currently I just want it on my localhost. What I want is to have a front page, where are normal posts like on wordpress, just simple posts, currently I don't want comments maybe later if it works cool :). And a very simple admin panel where I can manage the posts...
I have an application database on SQL Server 2008 Express on my dedicated server. It's not enough for my web app. Are there any good free conversion tools that will enable me to convert my current SQL Server database to MySQL on my server. Will my web app be able to work the same? ...
I have a database in access and one of the fields is 'Is Quick'. I have a query that filters all of these out. How would I get the data from that query in Visual Studio 2010 (Express). VB code please. ...
one websevers one website one page, three users clients two dbservers different databases on each using sql server 2005 server express when any of the client accessing the page from his computer clicks on button A ---- connect to 'table1' of db 'first' on dbserver1 button B ---- connect to 'table1' of db 'second' on dbsever2 questi...
As I know these two databases are the most popular and the best, but which one is the best? And what are the benefits to use one or other? Currently I use MySQL and I don't really have any experiences with Oracle, but I want to know what's the best choice and why? I mean how fast they are, what kind of features they have, how easy is t...
I am hosted on Winhost.com. They support both PHP and ASP.NET. I have a PHP User Management script and the instructions are as follows: Step 1 : Login to your web hosting account and create a database and inport the database.sql file. Step 2: Open config.php with notepad and change the settings to your database details. Step 3: Upload...
Hi In my app I have 2 tables that have a many to many relationship. Let us say these are table students and table courses. Each course can have many students and each student can also enroll in many courses. Now I want to create a associative table which according to cakephp should be named courses_students. However for various reason...
Hi! I'm rather confused right now about exactly how many unique ids MongoDB could generate for a single server. Of course, with multiple servers the server section of their id object would change too, but with a single server the only parts that would change seem to be the pid section (2 digits) and the incrementing section (4 digits). ...
Hey All, I was just wondering if it's at all possible to use XML as the database instead of SQL? And if there is any info about this somewhere? Thanks ...
I want to develop a C# <-> Database application. I've considered using a ORM creating me classes for transparent access to whatever database I want to connect to. I found nHibernate. But this seems very heavy and complicated to configure. My question: Is something out there that is lighter than nHibernate? Thanks, Andre Edit: Love yo...
I have uninstalled mysql from my system long ago and i have forgot the passowrd i have set to mysql now when i tried to install it its asking for the old password to set the new password in MySql sever instance configuration wizard i am not getting access to mysql command line client. ...
Greetings Overflowers, I'm wondering if there is a way to query some kind of a database and only fetch a certain window in the full result set without having to actually go through them all. For example, if I query my database and I want only results number 100 to 200, would the database fetch all the results (say 0 to 1000) that match...
I am creating a simple customer support tracking system with PHP/MySQL Fuctions are followings. An admin can CRUD an customer. An admin can add points/credits.: 60points (60min) etc An admin can enter the work details, date, time duration, points and display these and point(time) remaining. The question is how to structure the table...
Im an SQL noob. Heres my situation. I have the following tables. Customer_table Customer_ID | Last name | First Name | City_ID | Region_ID | Country_ID Country_table Country_ID | Country Region_table Region_ID | Region | Country_ID City_table City_ID | City | Region_ID | Country_ID I need to find the number of cus...
Greetings, I have a form which it has almost 150 checkbox, but they are not in one place, the form is divided into divisions and each division has blocks, the checkboxes are put in these blocks depending on their group where you can find four checkbox in this place and eight in other and 30 in some other and so go on. So I made a two t...
We are running a PHP (zend framework) app that creates a database per user (for security/backup/and others reasons). All these databases have exactly the same structure and that will always be the case. When we deploy new features we'll need to expand all databases with the new fields/tables. I've read about using dbdeploy for that, but...
A good example of what I want is a chat system, where I send a message to someone and he can instantly see my message and vice versa. So I want the best way to track if in the database there is a new answer for me if yes then show it with AJAX. Example Websites: Twitter Friend Feed ...
Ok so I understand that fmdb is totally outdated, and core data is where it's at, but for now, I just need to tweak an app I'm working on that uses fmdb to read from a sqlite db in the resources folder. I need to be able to write to my db. What is the best way to execute queries? I have tried doing the same thing that I do to read from...