I'm not really looking for a basic SQL guide but just something specific to PostgreSQL. And I do run my own servers so getting the latest version ( 8.2 I believe? ) is no issue. ...
Hi, I have an asp page based on a very simple database. It references a single table of probably 30 records and maybe 12 data fields and everything works great as I am only uploading a new database every week or so. I have a special circumstance where I would like upload new data to the database and display automatically on the page ev...
I'm developing an multi-user application which uses a (postgresql-)database to store its data. I wonder how much logic I should shift into the database? e.g. When a user is going to save some data he just entered. Should the application just send the data to the database and the database decides if the data is valid? Or should the appl...
What's the limitation? Is there a specific volume of data each can handle regardless of disk space? When to use what assuming licensing is not a problem? ...
I started my first MySQL project designing the ERD, logical and physical diagrams. A friend of mine is making the same project as me. I started the plan of my databases by making an ERD and then normalizing. However, he uses a relational database diagrams where he designs interfaces and other parts first before making the ERD. He for ...
Hello, in a client-server database application, the different options the client needs to read from the server, where you'd store them? In the database or in some file which will then will be transferred on the network, or is there any better way. ...
Hello to everybody, I'm trying to download a range of rows from my MySql database, through a cocoa app that I'm developing! To do all more easy, I use a php that receive an index from my app and send back all the rows up to that index. So, my cocoa code is: NSInteger index = 0; NSString *urlString = [NSString stringWithFormat:@"http://...
Hi, This is related to a similar question about BIND, but in this case I'm trying to see if there's any easy way to parse various zone files into a dictionary, list, or some other manageable data structure, with the final goal being committing the data to a database. I'm using BIND 8.4.7 and Python 2.4. I may be able to convince manag...
I read my notes and I am now unsure about the keys. My logical diagram This table should be in line with the following physical ERD I have only one foreign key in the table Question. I would like to know should the question-id and question-tag in the table Question-tag-xref, AND question-id and answer in the table Answers be a...
Following is the code to create a table in mysql database. CREATE TABLE IF NOT EXISTS `hightraffic` ( `id` int(11) NOT NULL auto_increment, `videoID` int(11) NOT NULL default '0', `userid` int(11) NOT NULL, `name` varchar(255) NOT NULL default '', `title` int(11) NOT NULL default '0', `date` datetime NOT NULL default '0000-0...
This question is based on the thread. If we have one-to-many data structure, we need to have a "help-table" to store for instance phonenumbers for one person. Many person cannot have the same phonenumbers. I look forward for an explanation why we then need two "help-tables" between many-to-many relations. An example of this is a questi...
Suppose we're making a system where we have to store the addrees for buildings, persons, cars, etc. The address 'format' should be something like: State (From a State list) County (From a County List) Street (free text, like '5th Avenue') Number (free text, like 'Chrysler Building, Floor 10, Office No. 10') (Yes I don't live in U.S...
I'm working on iPhone app that will let users upload/download photos to/from a DB server along with some data associated with each photo. While I do have experience with iPhone programing, I do not have much experience with DB and server side programing. Does anyone have any tips on what would be the easiest way to set up DB server...
Let's say there's an application which should create its own tables in main database if they are missing (for example application is run for a very first time). What way of doing this is more flexible, scalable and, let's say, more suitable for commercial product? If I code it all no additional files (scripts) are needed. User won't be ...
Hi, I was recently hired at a Software Engineering company and was put in charge of a new project for storing our analytics data. I want to give ORM a shot the mapping doesn't seem difficult but this problem has me vexed. This database will store data for Google Analytics, Quantcast, and any future analytics provider. I was pretty much ...
Hi , i wanna write a small (5-6 table) desktop app in java.I wanna use Firebird 2.1. database.But i googled and see HSQLDB.I wanna make a decision between firebird and hsqldb :) So which database i have to use ? ...
I'm considering the idea of creating a persistent storage like a dbms engine, what would be the benefits to create a custom binary format over directly cPickling the object and/or using the shelve module? ...
I have a JSP MySQL query <sql:query var="libraries" dataSource="jdbc/ArabiTagOnline"><br> SELECT l.LibraryId, v1.LAvalue AS "dbESTid", v2.LAValue AS "LibName", v3.LAValue AS "Desc" FROM ((Library l LEFT JOIN LibAttrValue v1 ON l.LibraryId = v1.LibraryId AND v1.AttributeId = 1) LEFT JOIN LibAttrValue v2 ON l.LibraryId = ...
As the title suggest, I was wondering if there is a Python module that can access an Advantage Database Server (Sybase) files such as ADT and DBF. I have searched the web and couldn't find what I'm looking for this is why I wanted to ask it here. ...
I have two servers: Server A: MySql Table A key-a foreign-key-b Server B: MsSql Table B key-b foreign-key-a Presumably I have two objects with methods that handle the relationships: TableA->getRelatedTableB(); TableB->getRelatedTableA(); This is easy to implement in most ORMs. But what if I want to get a large set of objec...