I've spent most of the day pouring over the web looking for
replication solutions for a peer-to-peer database architecture.
I'm writing software for networked embedded linux system that serves
up data using sqlite. Each peer on the network needs to have a copy of

    I was wondering: How do server-based DBMS (PostgreSQL, Oracle,
etc.) handle concurrent updates with optimistic locking?
Say user A sends a SELECT over the LAN to the server to grab an
employee's personal details, and feed them to a grid object on the

I have two tables, one called Department and the other called employee;
Department has two field: Deptname and id_dept
Employee has two fields: Empname and id_dept
I want to find out the name of those departments where the number of

I have this problem, I want to make report using PivotTable/CrossTab.
The problem is, I want so show NULL value to.
This is my query to get the data (I'm using an application that can
make pivottable from the data AND MySQL 5)

Hi there. I'm in need of assistance with an update query.  I am doing
a data migration for a message board.  All went fine except some of
the mappings didn't cross over.  Here is what I need to do:
Tables:

I am reading FUNDAMENTALS OF DATABASE SYSTEMS where it says "In general, a
query written with nested SELECT...FROM...WHERE... blocks and using = or IN
comparison operators can always be expressed as a single block query."
I believe this is true.

Whats the best network-FS for a Linux LVS cluster used as a web-server
for a (mysql)DB application?
I can use no network-FS and replicate the DB but then I have a problem
with session-management and also if the DB gets really large I run

Does anyone know the difference between UNION operator and the "OR" in
where clause ?
Thanks ahead.

I am using sesql.com to query Goggle with SQL and I am having trouble
with my query. The following works:
SELECT gog.*
FROM   google gog

I know how a database is working, but I am not familiar with the
available software.
I am just working with Filemaker Pro with about 15 clients, and I am
trying to evaluate other database solutions.

Hello all, recently, I read a good article from :
http://www.geekgirls.com/databases_from_scratch_3.htm
I have some question in my mind to achieve this.
In Step 11: Test sample data., Participants Table, a student may have

I'm having difficulty connecting to a mysql database that I have
running on a linux system. I am trying to connect from a windows
system - but I get "request returned with SQL error".  I have no
trouble connecting on the linux machine (localhost as server).  When I

Does anyone know where I can pick up an ODBC driver for NonStop SQL on
XP or how to install one manually?
Thanks

We see:
SELECT CompanyName
  FROM Customers

I am working on an electronic flashcard program. It will offer the
user a collection of "subjects" to study, such as: vocabulary,
history, geography, trivia, etc.
The program has the concept of "physical subjects" and "logical