Multi-user read/unread flag storage - Optimal DB Layout

I am trying to design tables to track if a given user has viewed a change/addition or not. The basic layout of the database presently is: DocumentTable DocID,FileName,Description,Cost,etc... ChangeTable ChangeID,Date,UserID,DocID,ChangeDescription By looking in the ChangeTable I can tell what i

RE: fulltext search option

So far as I know, the only way to accomplish what you want is to do what you tried: put the Boolean match in the WHERE clause and order by a natural match. That's what I do on our web site. By the way, you can't use prefix stemming: "*abcd" is the same as "abcd". Regards, Jerry Schwartz The Info

Re: Execute 3 Queries in Single Command

if you are using MySQL 5 you could use a stored procedure On 7/27/07, Samrat Kar <[EMAIL PROTECTED]> wrote: > > I want to execute three sql statements in single query which will perform > following task... > 1. select a particular row > 2. insert that row to another table > 3. delete that row from

Building MySql 5.0.45 on Solaris 6

Since my original post has been hijacked I'm writing a new one with maybe some more info. I have downloaded the GNU TAR source code. I'm using gcc 3.0.2 and GNU make 3.76.1 I have configure as follows CC=gcc CFLAGS="-O3" \ CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \ .

RE: Data Warehousing and MySQL vs PostgreSQL

Jochem, Yeah, I'm aware of partition pruning - and would be partitioning in such a way to ensure there is a small partition to be scanned/inserted to when required. I'm aware of timezone issues and we just use unix timestamps so there are no problems here. I'll look closer into MySQL's partition

Re: Data Warehousing and MySQL vs PostgreSQL

On 7/26/07, Andrew Armstrong wrote: > * Table 1: 80,000,000 rows - 9.5 GB > * Table 2: 1,000,000,000 rows - 8.9 GB > This is a generic star schema design for data warehousing. > I have read that it is better if perhaps partitioning is implemented, where > new data is added to a partiti

[ANN] BLOB streaming engine (MyBS), version 0.5 Alpha released

Hi All, I have just released version 0.5 of the BLOB streaming engine for MySQL. This version includes all the basic functionality required to stream BLOB data in and out of MySQL tables. The main features are: - Uploading of BLOB data directly into the database using HTTP PUT or GET meth

Re: Extract String only from varchar Field?

not to forget that there can also be street adresses like foobarstreet 23-25 or foobarstreet 17b and so on ... so i guess i'll have to split my addresses into 2 fields from now on (street and number). anyway thanks for ideas and replies! best: lars On 7/27/07, Joerg Bruehe <[EMAIL PROTECTED]> wrot

Re: Extract String only from varchar Field?

Hi Brent, Lars, all ! While I cannot offer a solution, I still know the "replace()" approach is incorrect: Brent Baisley wrote: The only regular expression MySQL support return a true/false if the expression was found. I had to do something similar to what you want to do. Although I needed

Execute 3 Queries in Single Command

I want to execute three sql statements in single query which will perform following task... 1. select a particular row 2. insert that row to another table 3. delete that row from 1st table in short, i want to move one row from table 1 to table 2 with single query.. thanks in advance for any sug

Re: Migration from Oracle to MySQL

On Thursday 26 July 2007 Rajesh Mehrotra's cat, walking on the keyboard, wrote: > Check out > http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html > Please note that PostgreSQL provides a gateway to other databases thanks to the DBI-Link extension, as well as it support more than o