Hi All, Have C# question; I've been searching for a way to lets say dynamic created objects at runtime by iterating though them and there properties/methods. so far i've played with using Reflections and foreach to illiterate the class properties. This is to display all records in various tables on a Data Grid view. However one approac...
I have two databases: Oracle 10G and SQL Server 2000. Inside the Oracle database, I have several MS Word documents stored as BLOBs. What I need to do is extract the files from Oracle and place them into SQL Server. I am curious as to how I do this? I have heard something about DTS but not sure if that is something to look into. ...
It is a quite common situation in our applications that some entity have to be represented by an enum: for example types, categories, status, and things like that. Often, there are conditions or flows in the code that use the values to decide between one action or another, so the values have to be "known" in some way for the applicatio...
Hi I have just started working on a project and I am using zend framework and postgresql (normally use MySQL) however I am hitting a problem when I am trying to get the last inserted id when using the Zend_Db insert command. When using the function $db->lastinsertid('users', 'userid'); I get the following error message: SQLSTATE[42P01...
I am interested in seeing suggestions for a database design regarding business hours. It would be quite similar to what Facebook has - I have a list of businesses, and I would like for users to be able to input multiple sets of available hours for that business. e.g., Monday: open 9-5; Tuesday: open 9-12; 1-5; etc. I would not like ...
I have made a small SQL database to hold some information about students. I want to save the data to the DB. I've been using the Datasource Wizard to dispaly/manage/save my data. It all works until I need to save. I double-clicked the save button and this is the code that is in there: this.Validate(); this.studentsBindingSource.EndEdit(...
I've looked at several approaches to enterprise architecture for databases that store massive amounts of data, and it usually comes down to more hardware, database sharding, and storing JSON objects. Has any group been doing research, or does anyone have a more dynamic approach that processes the available data and tells you how to bette...
I'm currently starting a new Java application using the H2 database, but I have some confusion about basic SQL use for creating tables. How do I make a table of entries (strings) each with unique, auto-incrementing, non-null, integer primary keys? One of the most basic things to do, but I'm not sure offhand what the correct way to do i...
Problem description: In my application, I have to present the contents of data packets with a certain format. An example: An example Any packed binary data, for example: 4 byte header, 4 byte type (type codes having pre-defined meanings), then source address, destination address, and so on. Previously, I made home cooked implementati...
I usually like to create the database connection myself and control its lifetime manually with `using{}'. For example: SqlConnection sqlConnection = new SqlConnection( connectionString ); using( sqlConnection ) { BusinessObject myBusinessObject = new BusinessObject( sqlConnection ); // do stuff with the business object ... }...
How do the relationships magically function when only the models are altered? If I want a "has__and___belongs___to__many" relationship, what should I name the table (so Rails can use it) that contains the two foreign keys? ...
I'm looking for a very high performance and cheap (hopefully free) database engine to be used on an x86 embedded platform in Windows CE. Can anyone give some suggestions? The important things I'm looking for are: High Performance (for a real-time system) Low cost Usable with Compact .NET framework Thanks ...
I'm currently working on basic user authentication for an app I'm putting together, and I don't have much experience with security. This said, I understand the practice (and necessity) of salting/storing a (salted) password hash in a database as a blob, as opposed to the password (encrypted or no). I've already implemented this. Is th...
How can we check which database locks are applied on which rows against a query batch? Any tool that highlights table row level locking in real time? DB: SQL Server 2005 ...
For a small project I need to utilize a simple database with very light requirements: few tables, no more than few thousands of records in total, 2 or 3 users. I am working in .NET environment. As a database server (even those Express editions) seems like a huge overkill in this case, a very simple MDB database could do for most of the ...
What are 'best-practices' for saving Composite patterns in a Relational Database? We have been using Modified Preorder Tree Traversal. This is very quick to build the whole tree, but very slow to insert or delete new nodes (all left and right values need to be adjusted). Also querying the children of a node is not easy and very slow. A...
I'm trying to run the following PHP script to do a simple database query: $db_host = "localhost"; $db_name = "showfinder"; $username = "user"; $password = "password"; $dbconn = pg_connect("host=$db_host dbname=$db_name user=$username password=$password") or die('Could not connect: ' . pg_last_error()); $query = 'SELECT * FROM sf_ba...
What's the best database admin software for OSX? maintain database schema and data run queries convert schema from one database type to another datapump to move data around schema diff tools, ideally able build a script to update a schema easy to use Databases I'm interested in are MSSQL PostgreSQL MySQL Firebird (SQLite) Prefe...
I once ran a home-made forum system for a small group of online deathmatch players. These forums have long since been shut down, and are currently offline. What I want to do is create static HTML files that contain all of the data for the entire system, in the interest of having an online archive that the former users could search. ...
I really want to know, how to secure a firebird database from being opened by any user but from the application it self. If I distribute a desktop application with a single file Firebird database (not embedded), how to protect the database from being copied to another machine running Firebird with known sysdba password? I have searched...