I am looking for a reference database that can be used to test for possible name typos in a contact database. This is for a batch process, so performance isn't a real issue. Ideally I'd like a comprehensive database, but even something like "top 5000" would go a long way. Thanks! ...
I come from a java background. But I would like a cross-platform perspective on what is considered best practice for persisting objects. The way I see it, there are 3 camps: ORM camp direct query camp e.g. JDBC/DAO, iBatis LINQ camp Do people still handcode queries (bypassing ORM) ? Why, considering the options available via JPA, D...
I’m looking for a Perl ORM library that has support for reverse engineering of the database schema. All I’ve found so far is http://perlorm.sourceforge.net/ and it appears to have no reverse engineering support. ...
Is it Oracle or MySQL or something they have built themselves? ...
How would I Export tables specifying only certain fields? I am using mysql 5.0 - using either a sql command or mysqldump. My table is X, and the fields I want to export are A,B,C ...
Hey everyone, Does anyone know a good (preferably open source and cross platform) tool to allow simple visualization of mysql databases? I just need a tool I can quickly point at a database and it'll show basic table structure and field types, etc. Nothing too advanced or crazy. ...
Short background: We are just starting to migrate/reimplement an ERP system to Java with Hibernate, targeting a concurrent user count of 50-100 users using the system. We use MS SQL Server as database server, which is good enough for this loads. Now, the old system doesn't use any transactions at all and relies for critical parts (e.g. ...
The project I am working on were are trying to come up with a solution for having the database and code be agile and be able to be built and deployed together. Since the application is a combination of code plus the database schema, and database code tables, you can not truly have a full build of the application unless you have a databa...
Is there an easy or straightforward way in Java to output the results of a DB Query to a file (either csv, tab, etc). Perhaps even in Hibernate? I know that a query results can be dumped to a flat file on the DB Server. I am looking for a way that an application can run a query and get those results into a file. I realize one option ...
I have a problem with a many-to-many relation in my tables, which is between an employee and instructor who work in a training centre. I cannot find the link between them, and I don't know how to get it. The employee fields are: employee no. employee name company name department job title business area mobile number ext ranking The ...
We are building an application on an embedded platform that needs a reasonably high performance database (very low select speeds on tables with > 500,000 entries). The database needs to be able to : Store atomic commit information in NVRAM so that such information is preserved if power fails before the commit finishes. Be written to N...
First, let me explain what I am doing. I need to take an order, which is split up into different databases, and print out this very large order. What I need from the orders is about 100 or so columns from different databases. The way I was doing in was querying with a join and assigning all of the column values to a variable in my one la...
Is there a way to avoid row deletion on an specific table using constrains? I'd like to (for example) deny row deletion if the id is 0,1 or 2 This is in order to avoid users deleting master accounts for an application, and I'd like to avoid it even if someone tries it (by mistake) using sql directly. Thanks! EDIT: The whole idea of ...
We have a Rails project that uses PostgreSQL-specific queries, so it's uncomfortable to use sqlite even in development mode. The problem is, I'd love to track schema changes in database and omit running migrations on request, and I'd also love to track db-data changes with git, so that I wouldn't need to dump the db and load it on my mac...
Given the schema PERSON { name, spouse } where PERSON.spouse is a foreign key to PERSON.name, NULLs will be necessary when a person is unmarried or we don't have any info. Going with the argument against nulls, how do you avoid them in this case? I have an alternate schema PERSON { name } SPOUSE { name1, name2 } where SPOUSE.na...
I've been working with Microsoft SQL Server with many years now but have only just recently started to use MySQL with my web applications, and I'm hungry for knowledge. To continue with the long line of "hidden feature" questions, I would like to know any hidden or handy features of MySQL which will hopefully improve my knowledge of thi...
Does anyone know of any gotachs or problems when writing multithreaded Perl applications using the Oracle DBI? Each thread would have it's own connection to Oracle. For the longest time I was told multithreading was not supported in Perl with Oracle. ...
I currently have a SQL Server (Express 2005) database to hold some transaction/metadata that I now want to migrate to Oracle 10g express instance. Can you do this programmatically or is there a decent software tool that anyone can recommend? ...
I have to display marks of my students through my site. the database is created using msaccess. how can I display the marks of each student in a table, as the enter the regno. ...
I am trying to convert some of my stored procedures to Linq and am having problems with the following Transact-Sql statement: Select Year(p.StartDate) As Year, (Select Sum(t.Units) From Time t Where Year(t.TransactionDate) = Year(p.StartDate)) As Hours, (Select Sum(i.Price) From Invoice i Where Year(i.CreatedDate) = Year(p....