How do I list the tables in a SQLite database file
What SQL can be used to list the tables, and the rows within those tables, in a SQLite database file once i've ATTACHed it on the sqlite3 command line tool? ...
database
What's wrong with foreign keys?
I remember hearing Joel Spolski mention in podcast 014 that he'd barely ever used a foreign key (if I remember correctly). However, to me they seem pretty vital to avoid duplication and subsequent data integrity problems throughout your database. Do people have some solid reasons as to why (to avoid a discussion in lines with Stack Over...
C++ Class design from database schema
I am writing a perl script to parse a mysql database schema and create C++ classes when necessary. My question is a pretty easy one, but us something I haven't really done before and don't know common practice. Any object of any of classes created will need to have "get" methods to popluate this information. So my questions are twofol...
How can I create and develop new database projects in Visual Studio?
I want to find a way to develop database projects quickly in Visual Studio. Any ideas? ...
How to update a field with random data?
I've got a new varchar(10) field in a database with 1000+ records. I'd like to update the table so I can have random data in the field. I'm looking for a SQL solution. I know I can use a cursor, but that seems inelegant. MS-SQL 2000,BTW ...
How do I do a manual uninstall of Oracle?
Sometimes my Oracle database on Windows gets hosed. How do I do a manual uninstall of Oracle? ...
Any good Derby DB Editor?
I would like to modify some Derby DB's structure, do you know any good (multiplataform) editor for doing this? thanks! ...
How do indicate the SQL default library in an IBM iSeries 2 connection string to an AS/400?
I'm connecting to an AS/400 stored procedure layer using the IBM iSeries Access for Windows package. This provides a .NET dll with classes similar to those in the System.Data namespace. As such we use their implementation of the connection class and provide it with a connection string. Does anyone know how I can amend the connection str...
Handling and storing elapsed time
I'm having problems deciding on what is the best way is to handle and store time measurements. I have an app that has a textbox that allows the users to input time in either hh:mm:ss or mm:ss format. So I was planning on parsing this string, tokenizing it on the colons and creating TimeSpan (or using TimeSpan.Parse() and just adding a...
Query a Table's Foreign Key relationships
For a given table 'foo', I need a query to generate a set of tables that have foreign keys that point to foo. I'm using Oracle 10G. ...
How do I enforce data integrity rules in my database?
I'm designing this collection of classes and abstract (MustInherit) classes… This is the database table where I'm going to store all this… As far as the Microsoft SQL Server database knows, those are all nullable ("Allow Nulls") columns. But really, that depends on the class stored there: LinkNode, HtmlPageNode, or CodePageNode. ...
How to best search against a DB with Lucene?
I am looking into mechanisms for better search capabilities against our database. It is currently a huge bottleneck (causing long-lasting queries that are hurting our database performance). My boss wanted me to look into Solr, but on closer inspection, it seems we actually want some kind of DB integration mechanism with Lucene itself. ...
What's a good way to store raster data?
I have a variety of time-series data stored on a more-or-less georeferenced grid, e.g. one value per 0.2 degrees of latitude and longitude. Currently the data are stored in text files, so at day-of-year 251 you might see: 251 12.76 12.55 12.55 12.34 [etc., 200 more values...] 13.02 12.95 12.70 12.40 [etc., 200 more values...] [etc., ...
How do you manage "pick lists" in a database.
I have an application with a number of "pick list" entities (used to populate single choice dropdown selection boxes). These entities need to be pulled from the database. How do I persist these entities in the database? Should I create a new table for each pick list? Is there a better solution? ...
How to edit sessions parameters on Oracle 10g XE?
default is 49 how to edit to higher? ...
Automated integration testing a C++ app with a database
I am introducing automated integration testing to a mature application that until now has only been manually tested. The app is Windows based and talks to a MySQL database. What is the best way (including details of any tools recommended) to keep tests independent of each other in terms of the database transactions that will occur? (...
How do you deal with NULL values in columns of type boolean in MS Access?
I was wondering if there is a better way to cope with MS-Access' inability to handle NULL for boolean-values other than change the column-data-type to integer. ...
how to connect oracle?
how to connect oracle by php on MAC OS X? oci? ...
SQLServer tempDB growing infinitely
Hi, we have several "production environments" (three servers each, with the same version of our system. Each one has a SQL Server Database as production database). In one of this environment the tempdb transaction log starts to grow fast and infinitely, we can´t find why. Same version of SO, SQL Server, application. No changes in the e...
How do I restore from a drop database command using a mysql binary log?
How can I restore a mysql database that was dropped using a "drop database" command? I have access to binary logs which should make this type of rollback possible. ...