RE: Convert Hebrew Text Between Codesets

2004-06-17 Thread Ilan Aisic
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 -Original Message- From: Oron Peled [mailto:[EMAIL PROTECTED] Sent:

Re: running wine using a read-only windows directory

2004-06-17 Thread Shachar Shemesh
Micha Feigin wrote: On Wed, Jun 16, 2004 at 06:16:20PM +0300, [EMAIL PROTECTED] wrote: If you have a Windows on your computer then you should be able to plug its NTFS driver into linux. Forgot what's the name of the project which makes this possible but you know the drill (google). It was

Re: [WEB Site] The First Maps Site on Linux?

2004-06-17 Thread Ben-Nes Michael
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

Re: mySql logs

2004-06-17 Thread Oded Arbel
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

Re: Convert Hebrew Text Between Codesets

2004-06-17 Thread Oded Arbel
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 (#1488; is Alef, '.' is '.'): Ok, for this part of the question (nobody

Re: quick MySQL howto, anyone?

2004-06-17 Thread Oded Arbel
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 instance).

Re: quick MySQL howto, anyone?

2004-06-17 Thread Omer Zak
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

Re: quick MySQL howto, anyone?

2004-06-17 Thread Ira Abramov
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? --

Re: [Israel.pm] Sorting By MySQL DATETIME Fields?

2004-06-17 Thread Noam Rathaus
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 that you

Re: quick MySQL howto, anyone?

2004-06-17 Thread Shachar Shemesh
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

Re: quick MySQL howto, anyone?

2004-06-17 Thread Ben-Nes Michael
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

Re: quick MySQL howto, anyone?

2004-06-17 Thread Ben-Nes Michael
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

[Job Offer] Lingnu is looking for a system administrator

2004-06-17 Thread Shachar Shemesh
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

Re: Has anyone got experience with adsl to 013 (Barak)?

2004-06-17 Thread Moish
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

Re: quick MySQL howto, anyone?

2004-06-17 Thread Oded Arbel
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

Re: quick MySQL howto, anyone?

2004-06-17 Thread 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(?) -- Tzafrir

Re: quick MySQL howto, anyone?

2004-06-17 Thread Tzafrir Cohen
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

Re: quick MySQL howto, anyone?

2004-06-17 Thread Sagi Bashari
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

Re: quick MySQL howto, anyone?

2004-06-17 Thread Shachar Shemesh
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

TCP timeouts in kernel 2.2

2004-06-17 Thread Ran Milstein
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,

Re: quick MySQL howto, anyone?

2004-06-17 Thread Sagi Bashari
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.

Re: quick MySQL howto, anyone?

2004-06-17 Thread Shachar Shemesh
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

Re: quick MySQL howto, anyone?

2004-06-17 Thread Sagi Bashari
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

Re: quick MySQL howto, anyone?

2004-06-17 Thread Oded Arbel
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

Re: Convert Hebrew Text Between Codesets

2004-06-17 Thread Micha Feigin
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 could try

Re: quick MySQL howto, anyone?

2004-06-17 Thread linux-il
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