I hope no one will shoot me :) but MySQL remind me Windows. they built
something simple and now trying to expand its capabilities without changing
the foult of the past.
Its not true that I didnt heard about MySQL new capabilities , its just that
they are special and not part of the basic package.
Ben-Nes Michael wrote:
MySQL state ( at least 2 years ago ) that you dont need transaction becouse
you can always cancel your inserts by initiatin deletes. all true if the
code is perfect (...)
Far from that - transactions mean that other clients outside the
transaction see a consistent state as if
On Thursday 17 June 2004 19:12, Shachar Shemesh wrote:
> Pg's disk data structure is built like a journaled file system, in order
> to give an assurance against precisely these type of problems. As far as
> I understood, MySQL's speed comes precisely from the lack of this
> structure.
They have b
On Thu, Jun 17, 2004 at 08:53:47AM +0200, Ilan Aisic wrote:
> You're right of course.
> Writing a simple conversion utility for this case is easy in any language.
> It must have been done before (probably for all the other codesets) and I didn't
> want to "invent the wheel".
>
> --ilan
>
You co
On 17/06/2004 19:12, Shachar Shemesh wrote:
Sagi Bashari wrote:
I can only speak from my experience. I never lost any data because of
MySQL. MySQL supports transactions for few years now so this is not
an issue for me.
I was mainly referring to data integrity in the face of power
failure/server
Sagi Bashari wrote:
I can only speak from my experience. I never lost any data because of
MySQL. MySQL supports transactions for few years now so this is not an
issue for me.
I was mainly referring to data integrity in the face of power
failure/server segmentation fault in the middle of a transa
Shachar Shemesh wrote:
Sagi Bashari wrote:
I've been working with MySQL for few (4?) years now, partly powering
few big israeli ecommerce websites. I only missed this feature once -
when we needed to do on the fly currency conversion. However, we
solved it by writing a small MySQL module in C.
Hi all,
I know this is quite an old kernel version
but if any off you can dig his memory and try to remember it will
help...
TCP allows you to open sockets with the
socket option which means if the connection is quiet (no messages) for at least
X time the TCP stack sends ACK message, ev
Walking on eggshells here, as I want answers, not to deteriorate into a
flame war. Please accept any objectionable statement in this email as
assign of the author's ignorance in MySQL, rather than a disqualifying
prejudice.
Sagi Bashari wrote:
I've been working with MySQL for few (4?) years now
Ben-Nes Michael wrote:
PG support real transactions and for long time.
So does MySQL (with InnoDB tables).
PG support Forigen Keys which for my openion is reason number one becouse
when you delete of a row you can tell the DB to delete all the otheres which
connected to it automaticly and dont h
On Thu, Jun 17, 2004 at 02:11:12PM +0300, Oded Arbel wrote:
>
> MySQL has developed a quite a lot since two years ago. it now has
> transactions,
IIRC transactions only work with a special and slower table format.
Is it still the case? If so: how much is it indeed slower?
--
Tzafrir Cohen
On Thu, Jun 17, 2004 at 02:34:02PM +0300, Ben-Nes Michael wrote:
>
> PG is more like Oracle, MySQL is a thin DB with few capabilities, which I
> will use only on one level database websites who needs only simple queris.
BTW: why not simpler non-server databases? sqlite, berkeley db(?)
--
Tzafri
On Thursday 17 June 2004 14:44, Ben-Nes Michael wrote:
> MySQL state ( at least 2 years ago )
MySQL has developed a quite a lot since two years ago. it now has
transactions, user functions (user procedures are available in the current
development branch, and if I may say so there are much more p
I'm using IPCOP with pppoe (used to have MDK and ipcop) .
Their support is very responsive as far as handling dns and such.
I can't tell you much about their technical support since I can't
recall any problems related to their services in the 18 months.
On Wednesday 16 June 2004 23:27, Oleg Gold
Hi all,
Lingnu Open Source Consulting Ltd. is looking for a Linux knowledgeable
system administrator. Job requirements:
1. Thorough understanding of the Linux operating system.
2. Auto deduction and "ideas person"
3. Self disciplined and reliable person
4. Good human relations, open to receiving k
as a follow up to my previous answer.
When i build web sites ( for example www.bazz.co.il ) i need to code much
less when working with PG becouse i have transaction and foreigen keys.
MySQL state ( at least 2 years ago ) that you dont need transaction becouse
you can always cancel your inserts by
To explain Why is way too long to list here but here is part of the thing:
PG developed since 1986 and is one of the most stable DB out there, and it
is real RDBMS while MySQL is not.
PG support real transactions and for long time.
PG support Forigen Keys which for my openion is reason number one
Ben-Nes Michael wrote:
Dont do my mistake, start with postgresql if you can.
MySQL is a bad DB unless you need one table Web Site.
Hi Michael,
Just so you don't feel as if I'm attacking, I'll mention that I didn't
do your mistake to begin with, and started with PostgreSQL (which is the
only da
On Wednesday 16 June 2004 21:12, Omer Zak wrote:
> On Wednesday 16 June 2004 12:14, Yuval Yaari wrote:
> > Hi,
> >
> > I had a query that used JOIN and took too much time (4 seconds).
> > I figured Perl could handle it much faster, and so it did.
>
> While Perl may be doing it faster, I'd suggest t
Quoting Ben-Nes Michael, from the post of Thu, 17 Jun:
> Dont do my mistake, start with postgresql if you can.
not my choice. I want a Hebrew Wiki, the best one around is MediaWiki'
and that works only with MySQL.
>
> MySQL is a bad DB unless you need one table Web Site.
care to list why?
--
Why?
I specified MySQL for two applications which I am developing. So, I
would like to know whether I should switch to PostgreSQL, based upon my
applications' requirements and your reported MySQL problems.
Ben-Nes Michael wrote:
Dont do my mistake, start with postgresql if you can.
MySQL is a b
On Thursday 17 June 2004 11:36, Ben-Nes Michael wrote:
> Dont do my mistake, start with postgresql if you can.
>
> MySQL is a bad DB unless you need one table Web Site.
> > I'm trying to find a simple a-b-c cookbook for Unix admins that are not
> > fluent in DB administration (i.e. myself dor inst
On Thursday 17 June 2004 08:25, Oron Peled wrote:
> On Wednesday 16 June 2004 11:58, Ilan Aisic wrote:
> > In particular, I'm interested in changing mutlibyte Hebrew to and from
> > HTML characters.
> > where:
> > The same in HTML ("א" is Alef, '.' is '.'):
>
> Ok, for this part of the question (no
On Thursday 17 June 2004 03:28, Tal Achituv wrote:
> Someone deleted one of my databases, and I would like to find out who...
> (which user and what time is enough)
unless you turned on detailed logs in your setup, you can't really have human
readable logs, mainly as logging every SQL query would
Dont do my mistake, start with postgresql if you can.
MySQL is a bad DB unless you need one table Web Site.
Cheers
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
---
this is far then being any GIS aplication.
Linux has lots of GIS solutions for web.
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--
- Original Message
26 matches
Mail list logo
