I am new to MySQL, but I have used Oracle for some time. I am a little confused about MySQL's LIMIT keyword. Does this keyword imply that the order of the returned data will be the same every time the query is executed? What if more data is added to the tables that affect the query? And how would the data be ordered if no order-by clause...
Hello SQLite is fine as a single-access database, but it gets risky when used by more than one user at a time. MySQL, Firebird, PostgreSQL etc. are more difficult to deploy and are simply overkill for my use. Ideally, I'd like a compact, single-EXE server meant to run on low-spec hardware (eg. 128MB RAM, 256MB flash RAM) that would be ...
Let's say you have a database with a single table like... --------------------------------------------- | Name | FavoriteFood | --------------------------------------------- | Alice | Pizza | | Mark | Sushi | | Jack | Pizza | ----...
Hi, Someone at my office has an access database which includes macros in the toolbar. To access it currently they have to log out of the domain and into a local user account. They would like others in the office to be able to access the database, which they can, but they cannot use the macros on the toolbars. The office version that is...
I am looking to see if there is a web based service I can either access programmatically to access teh following information, or a database I could purchase or interface with. I am looking to see if there are databases out there for: 1) Vehicle makes and models -- I recall something being out there in the $500/yr range 2) Vehicle Par...
A lot of sites post Jeopardy questions. But does anyone know if there are Jeopardy questions (and answers, categories) available in an computer application consumable format like in a database or Excel or CSV file? Assume this data will be fed into a Jeopardy online game. ...
I have been asked to look into FileMaker for creating a pretty simple database app. The application will handle contact information, some information about events hosted by the organization and - and this is where I'm currently struggling - RSVP information that link the contacts and events, as well as stores some data about payment. Wh...
Hi, In my iPhone app, I'm trying to delete a row from an SQLite database. After the delete statement is executed the row seems to be deleted correctly, but after I restart the application the row is still there. I'm using the code blow to delete the record. Any idea what could be the problem? NSString *deleteSQL = [NSString stringWithF...
I use temporary tables in an SQLite based iPhone application. Performance was not as was required so I looked at various candidates for optimization. Most of these worked well and had the desired effect. However, I'd also like to try moving the temporary tables from flash into memory to see if there is any improvement. On an actual de...
I'm currently trying to build (a simpler version of) a status website similar to Amazon's Service Health Dashboard Basically, I need to connect in about 3 Data Centers and a couple of websites with at least an Up/Down message. I'm mostly familiar with C# and some web programming. I'm slightly familiar with web services, and it looks li...
I'd like to generate insert-strings for a row in my Oracle database including all its dependent rows in other tables (and their dependent rows). Example: CREATE TABLE a ( a_id number PRIMARY KEY, name varchar2(100) ); CREATE TABLE b ( b_id number PRIMARY KEY, a_id number REFERENCES a(a_id) ); When I extract the row from a wit...
Hi I am a part of a student programming group an we are programming a social networking site. I have a Session bean and for every User i create a UserInfoHolder Class and my Session bean has an Instance of it. So 1 User = 1 UserHolder Instace = 1 Big Database query .. when logging in. Another Design Approach would be : No Holders. Dire...
As a junior programmer I think it may be beneficial to learn solid database design. What books would you recommend on learning database design? Just to be clear, the specific aspect of design I am referring to is creating a collection of tables and their relationships. Note: The programming books I have enjoyed reading (gaged by teachin...
Hello all, I'm trying to fill in for a colleague in doing some Oracle work, and ran into a snag. In attempting to write a script to modify a column to nullable, I ran into the lovely ORA-01451 error: ORA-01451: column to be modified to NULL cannot be modified to NULL This is happening because the column is already NULL. We have sev...
I'm in the process of porting some SQL Server 2005 databases to SQL Server 2008. One of these databases has an associated import application (Windows task) which uses SSIS with a DTS package to import a large dataset from an MS Access database nightly. In upgrading to SQL Server 2008, I discovered that I can't run the same console appl...
I have a mysql database table that will store locations for buildings and events and a few other things. All locations are stored in one table, and linked to buildings, events etc through their own many to many table. That way I can just display dots on a map, and also allow filtering etc. However the problem comes with some things havi...
Hello, Someone knows how to install ADOCE in a HP Jornada 720, that uses HPC 2000, please i have to develop an aplication for my company, and i have to use ADOCE in my Jornada 720, remember that i've tested the application and i've got an error that says that my Handheld didn't have the ActiveX to run that program. Sorry about my engli...
Here is a simple example of a django view with a potential race condition: # myapp/views.py from django.contrib.auth.models import User from my_libs import calculate_points def add_points(request): user = request.user user.points += calculate_points(user) user.save() The race condition should be fairly obvious: A user can...
Here is the situation,each page will show 30 topics,so I had execute 1 sql statements at least,besides,I also want to show how many relpies with each topic and who the author is,thus I have to use 30 statements to count the number of replpies and use other 30 statements to find the author.Finally,I got 61 statements,I really worry about ...
Hi, What is the best way to support multiple databases using hibernate? I see the following article... https://www.hibernate.org/429.html It seems Shards is a possible solution, though the con mentioned is that it's not appropriate for large numbers of schemas. My requirement, is that we have many different databases, multiple databa...