I'm trying to find databases with support for IP addresses as a native type (as opposed to storing as a string, or an unsigned integer, which at least one commenter has already pointed out won't work for IPv6). The primary reason I'm looking for this is ease of development. For example, sorting on a "native" IP address column would be co...
Hello experts, I've been working on this for the past few days and I can't find my way out of it. I have a C# web application that needs to print reports on screen. This same application calls a stored procedure on the database (Oracle) and it returns a cursor. Here is the procedure PROCEDURE report_total(beginDate IN DATE, endDate IN D...
Via this link, I know that a GUID is not good as a clustered index, but it can be uniquely created anywhere. It is required for some advanced SQL Server features like replication, etc. Is it considered bad design if I want to have a GUID column as a typical Primary Key ? Also this assumes a separate int identity column for my clustering...
I am building a blog archive navigation menu. Currently I run a query to get all the years and months. Then I loop through and run the following query to get all id's and titles of that year/months blog posts: SELECT `id`, `title` FROM `news` WHERE YEAR(`date`) = "2010" AND MONTH(`date`) = "03" ORDER BY `date` DESC After that, to...
Hello everybody, I am in dire need of help on how to explain what a data dictionary record is... I've been on Google all night and couldn't find a thing. From a few investigations I was able to find some information, which is below, but i don't know how to link them up nor find the correlation between them. The Topic I'm focusing on is...
We need to keep a copy of our legacy data for reporting purposes but our previous vendor is requesting we delete all copies of the old DB. Deleting the data makes no sense, it a very real sense that data is ours, but we're not sure of 'normal' legal ownership of the schema. Does anyone have experience of a previous supplier requiring all...
I am currently learning Cocoa. However I am coming from a traditional Sybase/Oracle background using Powerbuilder. Having been spoiled by the 'power' of a datawindow for may years, I not sure that coredata or sqllite will satisfy my needs and ideas. Basically I'm looking for some good reference sites, books, or just plain old advice on...
I want to have a column in a database that can contain multiple entries. Is it possible to have to define the type of the column as an array (fixed-sized array or some dynamic collection) so that it can store multiple entries. ...
via Excel 2003 vba I made dsn connection by this method Sub CreateDataSourceFile() Set fso = CreateObject("Scripting.FileSystemObject") Set txtfile = fso.CreateTextFile("C:\program files\Common Files\ODBC\Data Sources\" & Me.cnnName & ".dsn", True) txtfile.WriteLine ("[ODBC]") txtfile.WriteLine ("DBQ=" & Me.DBFolderName)...
Both seems to be generating integer NOT NULL UNIQUE REFERENCES databaase columns. Edit: My question is only about at the database level. (Not in the Django ORM.) ...
Hello! I'm using HeidiSQL ( http://www.heidisql.com/ ) to manage my databases at work (I prefer this over phpMyAdmin). Now, I want to use HeidiSQL with my personnal host plan, but when I connect to MySQL with my host, I connect with "localhost" in PHP but at work, I connect to databases with something like "supersqlserver.foo.net"... ...
I want to learn about olap and 'cubes', I have a very limited understanding and looking for recommendations on good beginner books on these sort of topics. I use sql server primarily so if the book is geared towards sql server it would be ideal. ...
Hi all, I'm trying to define a table in a SQL Server database that will hold rules. The rule data will be keyed on a number of columns. Where rules apply to a number of scenarios I want the the key columns to contain wildcards to avoid having to maintain lots of data. I then want to find the best match row with some kind of fuzzy search...
I need to synchronize two databases. Those databases stores same semantic objects but physically different across two databases. I plan to use a DTO Pattern to uniformize object representation : DB ----> DTO ----> MAPPING (Getters / Setters) ----> DTO ----> DB I think it's a better idea than physically synchronize using SQL Query on e...
I try to write an big test class. I'm using Junit, Hibernate and TopLink and H2 database. Before this I used EJB3Unit (including Hibernate and H2). My test class has 57 test methods. If I run all test at once randomized one or more test fails. If I run each test alone, I get no error. Has anyone an idea what's going wrong? And how I c...
I don't have too much experience with SQL. Most of the queries I have written have been very small. Whenever I see a very large query, I always kinda assume it needs to be optimized. But is this true? or is there situations where really large queries are just whats needed? BTW when I say large queries I mean queries that exceed 1000+ ch...
I am setting up a site using PHP and MySQL that is essentially just a web front-end to an existing database. Understandably my client is very keen to prevent anyone from being able to make a copy of the data in the database yet at the same time wants everything publicly available and even a "view all" link to display every record in the...
I recently decided to crawl over the indexes on one of our most heavily used databases to see which were suboptimal. I generated the built-in Index Usage Statistics report from SSMS, and it's showing me a great deal of information that I'm unsure how to understand. I found an article at Carpe Datum about the report, but it doesn't tell ...
I am working on an application with a few other people and we'd like to store our MySQL database in source control. My thoughts are two have two files: one would be the create script for the tables, etc, and the other would be the inserts for our sample data. Is this a good approach? Also, what's the best way to export this information? ...
my NSMutableArray creation code is being bypassed altogether for some reason. in theory it is supposed to create an NSMutableArray based on an sqlite database. There is only one warning message and no errors. what am I missing? the implementation file is: #import "iProspectFresno LiteAppDelegate.h" #import "MainViewController.h" #import...