What is the difference between CouchDB and Lotus Notes?
I was looking into the possibility of using CouchDB. I heard that it was similar to Lotus Notes which everyone loves to hate. Is this true? ...
database
Again with JPA not making sense
I asked this earlier and was to look at mapped by. I have 2 tables: A s_id(key) name cli type B sa_id(key) s_id user pwd. So in Jpa I have: @Entity class A...{ @OneToMany(fetch=FetchType.EAGER) @JoinTable( name="A_B", joinColumns={@JoinColumn(name="a_id", table="a",unique=false)}, inverseJoinColumns={@JoinCo...
Where can I find an open source C# project that uses ADO.NET?
I am trying to write a Windows Form and ASP.NET C# front-end and MSAccess backend for a pretty small database concept I have. I have written this application once before in just MSAccess but I now need the app and database to be in different places. I have now figured out (thanks to a StackOverflow user) that ADO will be a bad choice b...
Null or empty string to represent no data in table column?
Null or empty string -- is one better than the other to represent no data in a table column? (I specifically use MySQL, but I'm thinking this is system-independent.) Are there major advantages/disadvantages to using one over the other, or is it simply programmer preference? Thanks! ...
Is it possible to have separate SQLite databases within the same Django project?
I was considering creating a separate SQLite database for certain apps on a Django project. However, I did not want to use direct SQLite access if possible. Django-style ORM access to these database would be ideal. Is this possible? Thank you. ...
What's your #1 way to be careful with a live database?
For my customer I occasionally do work in their live database in order to fix a problem they have created for themselves, or in order to fix bad data that my product's bugs created. Much like Unix root access, it's just dangerous. What lessons should I learn ahead of time? What is the #1 thing you do to be careful about operating on l...
How do you measure all the queries that flow through your software?
In one of his blog articles, the proprietor of this web site posed this question to the reader, "You're automatically measuring all the queries that flow through your software, right?" How do you do this? Every line of code that makes a query against the database is followed by a line of code that increments a counter? Or, are there t...
Generate table relationship diagram from existing schema (SQL Server)
Is there a tool around that would produce a diagram showing existing tables and their relationships given a connection to a database or by any other means? This is for SQL Server 2008 Express Edition. ...
Using Database entries to dynamically create a visio diagram
Is this possible? We have a Configuration Management Database that stores information such as our servers, what datacentre they're stored in, applications that reside on them, as well as interfaces that send data from one application to another. We would like to use Visio to connect to our SQL 2005 database, and automatically generat...
How to get effect of sorted database view?
I'd like to be able to (effectively) sort a database view - I know that conceptually order in a db view is invalid, but I have the following scenario to deal with: a third-party legacy application, that reads data from database tables using a select(*) from tablename statement the legacy application is very sensitive to the order of th...
Is it possible to order by any column given a stored procedure parameter in SQL Server?
I was looking into sorting tables by a column designated given some input, and from what I've found, there is no easy way to do this. The best I've found is a switch statement: SELECT Column1, Column2, Column3, Column4 FROM Table ORDER BY CASE WHEN @OrderBY = 'Column1' THEN Column1 WHEN @OrderBY = 'Column2' THEN Column2 ...
Is it possible to query a tree structure table in MySQL in a single query, to any depth?
I'm thinking the answer is no, but I'd love it it anybody had any insight into how to crawl a tree structure to any depth in SQL (MySQL), but with a single query More specifically, given a tree structured table (id, data, data, parent_id), and one row in the table, is it possible to get all descendants (child/grandchild/etc), or for tha...
What is your experience with auditing features (Oracle)?
Did you ever use Oracle auditing features on a production db? How did that impact on performances, and are there differences you noticed between different versions of Oracle? ...
What are the performance improvement of Sequential Guid over standard Guid?
Has someone ever measured performance of Sequential Guid vs. Standard Guid when used as Primary Keys inside a database? ...
Maintaining consistency when using temp backup tables
This is related to the accepted answer for What’s your #1 way to be careful with a live database? Suppose you create a temp table for backup purpose and make your changes in the original. The changes break the system and you want to restore the backup. In the meantime some other records have also changed in the original table (it is a l...
Why have object oriented databases not been succesful (yet) ?
That's the question. Give only one reason you think why have OODB failed or why many systems nowadays still use relational databases. ...
Can I put a caching server in front of my web site?
I have a web site using apache httpd as the server and mysql as the backend. It publishes a "thought for the day" that has gotten so popular that the server is crashing due to the number of requests. Since the same page is been requested (the thought only changes once a day), is it possible to put a caching server in front of my main ser...
Row Level Security with Entity Framework
I've been trying to consider how Row Level Security could be implemented with the Entity Framework. The idea is to have a database agnostic means that would offer methods to restrict the rows coming from the ObjectContext. Some of my inital ideas have involved modifying the partial classes created by the EDMGEN tool and that has offere...
One to One database relation?
In my free time I started writing a small multiplayer game with a database backend. I was looking to separate player login information from other in game information (inventory, stats, and status) and a friend brought up this might not be the best idea. Would it be better to lump everything together in one table? ...
Standard connection libraries for MySQL, MSSQL, and Oracle in PHP
Hello, I'm looking for a standard way to connect to databases in PHP. We've all been there - first start with some rudimentary code to connect/query/iterate/insert/disconnect, then the code grew as the program grew, and it ended up with a mess that's hardly reusable. I know there are many PEAR, PECL, and other PHP libraries/classes out...