I am designing this database that must maintain a history of employee salary and the movements within the organization. Basically, my design has 3 tables (I mean, there more tables but for this question I'll mention 3, so bear with me). Employee table (containing the most current salary, position data, etc), SalaryHistory table (salary, ...
Is it possible to use Toplink Essentials without application server, just on desktop application? ...
Hi, I'm going to build a book store in which we have 3 entities(classes): Seller,Buyer,Book. I've designed the database as the following details: - Both buyer and seller can buy/sell one or more books respectively. - A buyer needs a seller account if he/she wants to sell a book. - Buyers will offer their price and seller would like to se...
Hi, I have a MySQL table with an auto increment primary keys... I deleted some rows in the middle of the table. Now I have, for example, something like this in the ID column: 12, 13, 14, 19, 20... I deleted the 15, 16, 18 and 19 rows.... I want to reassing/reset/reorder the primary keys so I have continuity... make the 19 a 15, the 20 a ...
I have a table called 'movie2person' with 3 columns: movieID, personID and role. I use this table to connect betwen the 'movies' table and the 'persons' table... many-to-many relationship.. I have selected movieID and personID both as primary keys... The problem is that sometimes I need to enter the same personID for the same movieID se...
What's the preferred (best practice) means of connecting an ASP.Net Website to a database? I doubt it's as simple as using Trusted-Connection and giving the NT-Authority accounts access. What do y'all do? Assuming a clean install of SQL Server (2008), what do you do to configure access to the database for a website? ...
Background: I'm building a poetry site with user submitted content. The relevant user actions for my questions are that users can: a. Go to fancysitename.com/view to see all poems so far b. Go to fancysitename.com/submit to submit your own poem. c. Go to fancysitename.com/apoemid to view a particular poem you've bookmarked befo...
I'm writing a CAD (Computer-Aided Design) application. I'll need to ship a library of 3d objects with this product. These are simple objects made up of nothing more than 3d coordinates and there are going to be no more than about 300 of them. I'm considering using a relational database for this purpose. But given my simple needs, I don'...
Have a huge mysql table with like 300,000 records and wanted to page the records in PHP (not the point here though) with a query in this manner: SELECT * FROM `table` LIMIT 250000, 100 It could be majorly slow in the latter part of the records, especially when near the end of the table (LIMIT start very large). My guess is MySQL has t...
We are building an application which requires a daily insertion of approximately 1.5 million rows of data per table. We have 16 tables. We keep track of 3-day historical data including the current day's data. The application is done using C#; on the server side, we run an exe that fills the data tables during market hours (4.5 hours), a...
Hello, I've recently started work on a project which involves creating a web-based reporting interface for a fairly old software responsible for managing some access control hardware like electronic door locks for example. I have chosen CakePHP for the task and all it involves is querying the database for the log records and displaying ...
Hi I have a database table, let's call it Countries. Countries all have names, short names and continents. Let's assume that the longest name of any country in the world is 54 characters long. Should I set the maximum size to 54 or should I set it to e.g. 64 or something else? Will my choice affect queries or storage in any way? I ...
How can I update my JTable data automatically when my database is updated? Thanks. ...
Hi, I've made an ASP.NET 2.0 website and it uses two databases namely aspnetdb and my_db.I ran the aspnet_regsql.exe -E -S localhost -A mr tool and I got the aspnetdb.mdf in my project.I used it for providing login features to my site. Now i want to publish the site to a remote hosting server which I've purchased. They have provided me ...
I'm using cakePHP and I want to add a First and Last name column to the Users table, but when I pass through the field values firstname & lastname the columns are always left null, while the default fields are populate fine. Is it possible to do this or do I need to have a second table to store these values? Update code: Registration ...
So I'm setting up an installer for my web app, and have input fields for database credentials. Part of my validation process includes testing the database connection (using PHP's PDO library). If the connection fails, I want to be able to differentiate between a bad password, bad address, nonexistent database name, etc. so I can referenc...
This morning, I read a very good question about what the person should expect from a Sharepoint position. I have a similar question about server side engineering. What can I expect from server side engineering positions, and how is it similar and different from desktop development? I have experience with WinForms, WPF, some light mu...
What is the best way to have many children records pointing to one parent record in the same model/table in Django? Is this implementation correct?: class TABLE(models.Model): id = models.AutoField(primary_key=True) parent = models.ForeignKey("TABLE", unique=False) ...
We have large SQL Server 2008 databases. Very often we'll have to run massive data imports into the databases that take a couple hours. During that time everyone else's read and small write speeds slow down a ton. I'm looking for a solution where maybe we setup one database server that is used for bulk writing and then two other databa...
When pulling data from a MySQL database onto a web page, all ellipsis's(...) in the data are displayed with a � in firefox or a square box in IE7. Has anyone ever encountered this problem before? Thanks. update 1: I just changed the original ellipsis '…' with '...' (three dots) and now it works? Any idea what this could be? ...