Re: Stress-testing SQLite

2010-10-30 Thread Kee Nethery
many of the data stores for the major apple apps use sqlite. it's a petty 
robust single user data store. 
kee nethery


On Oct 29, 2010, at 5:32 PM, Mark Stuart wrote:

 on Fri Oct 29 19:17:40 CDT 2010, Richard Gaskin wrote:
 
 Thanks in advance for sharing your experiences with large data sets if 
 SQLite.
 
 
 Hi Richard,
 How many tables and how many columns per table (on average) are you
 talking about?
 That can make a big difference to the performance if there are JOINS
 involved.
 
 If not, then that's not so much a problem.
 
 Will the user always apply a WHERE filter to the data?
 What's the potential return record set count on a typical filter?
 
 I'd be happy to do some stress testing if you can give me some details.
 
 Regards,
 Mark Stuart
 ___
 use-revolution mailing list
 use-revolution@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-revolution




-
I check email roughly 2 to 3 times per day. 
Kagi main office: +1 (510) 550-1336



___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Stress-testing SQLite -- millions records? Use Valentina DB

2010-10-30 Thread Ruslan Zasukhin
On 10/30/10 3:17 AM, Richard Gaskin ambassa...@fourthworld.com wrote:

Hi Richard,

 I have a need coming up for a data store that can robustly handle at
 least a million records, ideally up to five million, where each record
 may be as large as 5k.
 
 I don't need relationality, so for me SQLite is an option but only an
 option; I'm happy to consider other options as well. (Yes, it has to be
 SQLite rather than MySQL, because it needs to work embedded with a
 commercial application).

Valentina DB is faster 100 times of SqlLite, mySQL

And can be perfectly embedded into commercial application because it is
royalty free.

 
 Have any of you done stress testing on SQLite to that degree?
 
 I've tried finding even anecdotal data on the web for SQLite limits, and
 while I can find citations of theoretical limits I haven't come across
 real-world usage stories of data sets that large.
 
 Should I be confident in SQLite as a storage solution for that?  Should
 I be scared?

SCARED :)
 
 Thanks in advance for sharing your experiences with large data sets if
 SQLite.

You need Valentina DB.

Okay you need 5K for each record.
How many fields?

Let me remind that Valentina has columnar format.
This is huge advantage.

Also Valentina can give you not only SQL way but NON-SQL way,
Which can be additionally 10-20 times faster!

--
I can tell you store, that Valentina was tested for AOL Europe by their dev
team. Against Berkly,  mySQL, postgre, and other dbs. SqlLite even was not
in game of course.

Task was so simple. Table has 2 fields {URL, PictureBannerAd }

So when somebody ask for a WEB page, it needs find banner to be shown.

As they told, e.g. Berkly have give 100 faults per time (min our hour I not
remember now).  Other dbs also. Fault means that banner was not found  by DB
in time less of timeout.

Valentina have give them zero faults.


Let me underline this very important feature NON-SQL-ness of Valentina.
As well as very powerful SQL.

Today is very modern stream talk about how SQL DBs are bad, and how cool are
NON-SQL with Key-Value.  Guys, be happy, Valentina is perfect for both
tasks. :-)

If talk about details, in V4REV API (and most others Valentina ADKs) you can
use not SQL way to do searches and sortngs using
   VField_FindValue()
   VField_FindRange()
   VField_FindLike()

And other similar search methods.  They are really FASTEST POSIBLE way.
 

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: [OT] G3 and USB 2

2010-10-30 Thread Richmond

On 10/30/2010 04:22 AM, -=JB=- wrote:

Have tried shutting down the computer and rebooting with them
still plugged in?  If not that will probably mount them but it will
be the same everytime.

-=JB=-



That is exactly what I did.


On Oct 29, 2010, at 12:30 PM, Richmond wrote:


So; having got a generic USB 2.0 PCI card recognised in my
Back-to-the-Future G3 Mac I have started having a lot of 'fun' with it:

1. It works very well with my faithful Belkin Nostromo.

2. When I plug 2 external USB 2 hard-drives into it they are
 not recognised AND nor is the Nostromo.

Queer or what?
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: [OT] G3 and USB 2

2010-10-30 Thread Richmond

On 10/30/2010 05:28 AM, -=JB=- wrote:

I forgot to mention also have the drive turned on.  In other words every
time you want to mount the drive have the computer shut down make
sure the drives are plugged in and turned on then boot the computer.

-=JB=-


On Oct 29, 2010, at 6:22 PM, -=JB wrote:



Ah; could be the problem; end of plug-n-pray . . .  :)


Have tried shutting down the computer and rebooting with them
still plugged in?  If not that will probably mount them but it will
be the same everytime.

-=JB=-


On Oct 29, 2010, at 12:30 PM, Richmond wrote:


So; having got a generic USB 2.0 PCI card recognised in my
Back-to-the-Future G3 Mac I have started having a lot of 'fun' with it:

1. It works very well with my faithful Belkin Nostromo.

2. When I plug 2 external USB 2 hard-drives into it they are
not recognised AND nor is the Nostromo.

Queer or what?
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Stress-testing SQLite -- degradation on big selections

2010-10-30 Thread Ruslan Zasukhin
On 10/30/10 4:10 AM, Richard Gaskin ambassa...@fourthworld.com wrote:

Hi Richard,
Hi Mark,

 Mark Stuart wrote:
 
 on Fri Oct 29 19:17:40 CDT 2010, Richard Gaskin wrote:
 
 Thanks in advance for sharing your experiences with large data sets if
 SQLite.
 
 
 Hi Richard,
 How many tables and how many columns per table (on average) are you
 talking about?
 
 Probably just a single table, with about 20 columns.

Okay this answers my question.

So now I can tell you Richard, ONLY because of columnar format,
Valentina DB can do some operations 20 times faster of any ROW-based DB.

And if multiply this to other features of Valentina you can become
With Valentina 20 *4 * 2 = 100-200 times faster.


 If not, then that's not so much a problem.
 
 Good to hear.

Very not true :)

When you talk about speed and time, all is relative.
You need talk about ABSOLUTE numbers instead.
   
For one person/project/app 10 sec for search is very fast,
For another this is incredibly slow.

Richard, when you say, I NEED SPEED, you must say:
  I want query in 100 sec or in 0.01 sec

Only having this info, people can advice you.

 
 What's the potential return record set count on a typical filter?
 
 It'll vary, and in my own tests that seems to be the only bottleneck
 with SQLit; queries that return little data are ultra speedy, but once
 we get into large amounts of return data I see the hit.

Exactly Richard. 

This is named degradation of DB on grow of

A) records number in table(s)
B) records number in the RESULT

Yet from 1996 year, when I did my first benches of Valentina against
 FileMaker, 4D, Access, mySQL, ...

And this very first thing I have found also.

Most dbs if not all, have powerful degradation when recs number grow.

Also exists some special N related to RAM of computer. Below this N dbs go
yet more or less nice. After N degradation can go by jump x10 worse.

With Valentina this N was much higher in the same RAM, because of much more
compact db format for data. And after N it was very good yet.


For example, if for most dbs difference in time between 50 and 500,000 recs
in result is huge, for Valentina it is almost flat.


 
 I'd be happy to do some stress testing if you can give me some details.
 
 Thanks.  Don't knock yourself out; I'll be continuing with my own tests
 here, but if this sort of thing passes for entertainment in your house
 then of course I'd be grateful for any details you turn up.
 
 --
   Richard Gaskin
   Fourth World
   LiveCode training and consulting: http://www.fourthworld.com
   Webzine for LiveCode developers: http://www.LiveCodeJournal.com
   LiveCode Journal blog: http://LiveCodejournal.com/blog.irv

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: the siglum key ???

2010-10-30 Thread Richmond
Ugh; Apple, not content with hiding the # key from people on the East 
side of the Atlantic
have also been playing silly buggers with the physical layout of 
keyboards:


For instance:

My non-American (this includes my English  Arabic Mac keyboard) 
keyboards have a
siglum key in the top-left corner = rawKeyDown 0, and American keyboards 
have a

funny apostrophe key in the same place = rawKeyDown 96.  rawKeyDown 96 on
the non-American keyboards is snuggled down left of the Z key.

For virtual keyboard people (like myself) working with LiveCode this is
a right pox as, frankly, the thought of trying to set up some sort of 
keyboard

detection routine followed by a dance of the vampires sort of arrangement
whereby various buttons would merrily shift their position depending on 
the keyboard

layout gives me the willies . . .

Err . . . anybody know a way, within LiveCode/RunRev to detect an end-user's
physical keyboard?

--

Francophones get a free word study exercise with most of my postings . 
. .  :)


NOW; in your livres vocabulaires, s'il vous plait?

1. Pox

2. Willies

3. Silly Buggers

4. Snuggle down

and may you all curse me for the hoofdpijn . . .  :)



Happy Saturday, Richmond.
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: the siglum key ???

2010-10-30 Thread Jacques Hausser

Le 30 oct. 2010 à 09:34, Richmond a écrit :

 Ugh; Apple, not content with hiding the # key from people on the East side of 
 the Atlantic
 have also been playing silly buggers with the physical layout of keyboards:
 
 For instance:
 
 My non-American (this includes my English  Arabic Mac keyboard) keyboards 
 have a
 siglum key in the top-left corner = rawKeyDown 0, and American keyboards have 
 a
 funny apostrophe key in the same place = rawKeyDown 96.  rawKeyDown 96 on
 the non-American keyboards is snuggled down left of the Z key.
 
 For virtual keyboard people (like myself) working with LiveCode this is
 a right pox as, frankly, the thought of trying to set up some sort of keyboard
 detection routine followed by a dance of the vampires sort of arrangement
 whereby various buttons would merrily shift their position depending on the 
 keyboard
 layout gives me the willies . . .
 
 Err . . . anybody know a way, within LiveCode/RunRev to detect an end-user's
 physical keyboard?

THAT's a really good question ! Not sure my answer is the best one:

if you

put URL file:/library/preferences/com.apple.HIToolbox.plist into tKeyboard 

the variable tKeyboard will contain something like:

bplist00fl 
#$%+-./_AppleNumberResID_AppleItlbNumber_ApplePreviousInputSource]AppleItlbKeys]Keyboard
Menu_AppleSelectedInputSources^AppleDateResID_AppleCurrentAsciiInputSource_'AppleCurrentKeyboardLayoutInputSourceID]AppleItlbDate_AppleEnabledInputSources_AppleInputSourceHistory_AppleKeyboardScript_AppleCurrentInputSource_AppleDefaultAsciiInputSource^AppleTimeResID—WsmRoman—?ˇ”_InputSourceKind_KeyboardLayout
 Name_KeyboardLayout ID_Keyboard Layout\Swiss French——Vkcfg 
0OtWflW‡GP 

I\?¨?≠?Ø?Æ°!”—”_com.apple.keylayout.SwissFrench—¢'*”()VFrench”°,”””—+Pkyá£≤—˚
   $Tnçúüß©¨Ø∂»fiÚïóû°® 
Õ–◊fi‡ÁÈ˜˛0

you can drop the unnnecessary things by

delete char 1 to (offset(apple.keyLayout.,tKeyboard) of tKeyboard
delete char (offset(—,-1)) of tKeyboard

... and tKeyboard should contain SwissFrench (on my Mac, at least)

I'm to lazy to check what mean the remaining stuff; perhaps something useful...


 
 --
 
 Francophones get a free word study exercise with most of my postings . . .  
 :)
 
 NOW; in your livres vocabulaires, s'il vous plait?
 

traduttore tradittore... in the context of your post, I would translate

1. Pox  a right pox: une vraie saloperie

2. Willies  it gives me the willies: ça me fiche les jetons

3. Silly Buggersbougres de cinglés (bougre - and bugger) originally 
means bulgarian, eh, eh...

4. Snuggle down camouflé sous 

and may you all curse me for the hoofdpijn . . .  :)  I'm giving up !

 
 
 Happy Saturday, Richmond.

et bon dimanche, Jacques

 ___
 use-revolution mailing list
 use-revolution@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-revolution

**
Prof. Jacques Hausser
Department of Ecology and Evolution
Biophore / Sorge
University of Lausanne
CH 1015 Lausanne
please use my private address:
6 route de Burtigny
CH-1269 Bassins
tel/fax:++ 41 22 366 19 40
mobile: ++ 41 79 757 05 24
E-Mail: jacques.haus...@unil.ch
***

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: the siglum key ???

2010-10-30 Thread Jacques Hausser

Le 30 oct. 2010 à 13:28, Jacques Hausser a écrit :

 delete char (offset(—,-1)) of tKeyboard

sorry, it should be:  delete char (offset(—,tKeyboard)) to -1 of tKeyboard

J.

**
Prof. Jacques Hausser
Department of Ecology and Evolution
Biophore / Sorge
University of Lausanne
CH 1015 Lausanne
please use my private address:
6 route de Burtigny
CH-1269 Bassins
tel/fax:++ 41 22 366 19 40
mobile: ++ 41 79 757 05 24
E-Mail: jacques.haus...@unil.ch
***

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


How to reorder lines in a list field

2010-10-30 Thread André Bisseret

Bonjour,

I am trying to get a list field where it would be possible to reorder  
the lines.

(is there somewhere any tutorial or any solution on this?)

I started from a script from Éric Chatonet that allow moving lines  
from field1 to field2, modifying it to drag lines in one field only.


I succeeded in a test stack:  in a list field, all works as expected  
with a dragImage).


My problem is that when I put exactly the same script in a field of an  
app. I am developing, it does not works any more:
The dragged line is deleted when releasing the mouse (except if I drag  
outside the field and then back in it: then that works


I am fighting with that for hours now, and can't find what is wrong.

My last surprise is that if I don't create (set) any dragImage, then  
all works as expected.


I am getting crazy
The worst thing is that the same script works well in a field on my  
test stack and not on the field on my other stack (the two fields have  
exactly the same properties).


Any idea on what could be wrong?

Thanks a lot in advance

Best regards from Grenoble

André





___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: the siglum key ???

2010-10-30 Thread Björnke von Gierke
On 30 Oct 2010, at 09:34, Richmond wrote:

 Err . . . anybody know a way, within LiveCode/RunRev to detect an end-user's
 physical keyboard?

I am someone who uses and analyses a lot of games, where keyboard features are 
often mapped to position instead of char-output. Basically the answer to your 
question is no. Sure, there are ways to find out some information about the 
layout, but keybord layouts are not normed in any way beyond thats how they 
always did it.

A simple example is the difference of an older swiss-german mac layout versus 
an american layout (those being the two i have here right now):

for swiss layout vs us layout:
the row that starts with q has one more key at the rightmost position
the row that starts with a has one less key at the rightmost position
the row that starts with z doesn't start with z, it starts with , and then 
continues with y (y and z are always switched in german layouts vs us layouts).
The return key is not a double key in width, but instead a double height (with 
some adjustment to width because the rows are shifted slightly compared to each 
other, producing a hook-looking key)
Instead of a second alt key to the right of the spacebar, there's a return key 
on my ibook (newer macs don't have that anymore)
Obviously a lot of chars are mixed and moved around, for example shift- and 
then the numbers at the top (from 1 to 0):
swiss german: +*ç%/()=
usa: !...@#$%^*()

now, on my windows pc (swiss german layout), there's an alt-gr key to the right 
of the spacebar, which allows the typing of funny chars like |,€,¢, etc.
there's also a windows and a menu key, which macs won't ever have (they have 
the command key instead).

And that's only comparing three keyboards that I have here. If you want to 
catalogue all keyboard layouts of the world, I'm sure you could sell big buck 
licenses to all the game developers who do this stuff on a far less 
sophisticated ground: Every user can adjust his preferred layout nilly willy, 
and only the most often seen ones are (maybe) build in. 

And then there's dvorak.

For example Starcraft 2, one of the biggest budget games of the year, has fixed 
layouts to reduce cheating vectors. these layouts are always bugged for a 
certain percent of the community, and the answer to those is: memorise or lose 
the game.


-- 

official ChatRev page:
http://bjoernke.com?target=chatrev

Chat with other RunRev developers:
go stack URL http://bjoernke.com/chatrev/chatrev1.3b3.rev;

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: How to reorder lines in a list field

2010-10-30 Thread Jacques Hausser
Bonjour,

Eric Chatonet also published a how to that does exactly what you want:

http://www.sosmartsoftware.com/?r=telechargerl=enarch=tutorials//List%20reorganizing.rev.zip

Good luck

Jacques

Le 30 oct. 2010 à 15:18, André Bisseret a écrit :

 Bonjour,
 
 I am trying to get a list field where it would be possible to reorder the 
 lines.
 (is there somewhere any tutorial or any solution on this?)
 
 I started from a script from Éric Chatonet that allow moving lines from 
 field1 to field2, modifying it to drag lines in one field only.
 
 I succeeded in a test stack:  in a list field, all works as expected with a 
 dragImage).
 
 My problem is that when I put exactly the same script in a field of an app. I 
 am developing, it does not works any more:
 The dragged line is deleted when releasing the mouse (except if I drag 
 outside the field and then back in it: then that works
 
 I am fighting with that for hours now, and can't find what is wrong.
 
 My last surprise is that if I don't create (set) any dragImage, then all 
 works as expected.
 
 I am getting crazy
 The worst thing is that the same script works well in a field on my test 
 stack and not on the field on my other stack (the two fields have exactly the 
 same properties).
 
 Any idea on what could be wrong?
 
 Thanks a lot in advance
 
 Best regards from Grenoble
 
 André
 
 
 
 
 
 ___
 use-revolution mailing list
 use-revolution@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-revolution

**
Prof. Jacques Hausser
Department of Ecology and Evolution
Biophore / Sorge
University of Lausanne
CH 1015 Lausanne
please use my private address:
6 route de Burtigny
CH-1269 Bassins
tel/fax:++ 41 22 366 19 40
mobile: ++ 41 79 757 05 24
E-Mail: jacques.haus...@unil.ch
***

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: the siglum key ???

2010-10-30 Thread Mike Bonner
This might be useful, or discouraging.

http://support.apple.com/kb/HT2841
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: How to reorder lines in a list field

2010-10-30 Thread Björnke von Gierke
I can't help you with code from someone else that I have no intention of 
looking at. Most likely a mouseenter or mouseleave doesn't trigger, no clue. 
For reordering lines, there's no build in way, and there are many possible ways 
to do it. Here's mine. It uses just the list field, and is probably a bit 
simplistic (no floating line/drag image following the mouse cursor). But it 
works for a single selection list field.

on mousedown
  put the selectedText of me into myDrag
  put the mouseLine into mySelection
  repeat while the mouse is down
put the mouseLine into toSelect
if mySelection  toSelect and toSelect   then
  put the scroll of me into theScroll
  put me into theText
  put word 2 of toSelect into LinetoSelect
  if lineToSelect = the number of lines of me then
delete line (word 2 of mySelection) of theText
put return  myDrag after line -1 of theText
  else
delete line (word 2 of mySelection) of theText
put myDrag  return before line lineToSelect of theText
  end if
  put toSelect into mySelection
  lock screen
  put theText into me
  set the scroll of me to theScroll
  select line (word 2 of myselection) of me
  unlock screen
end if
  end repeat
  showSettings
end mouseDown


On 30 Oct 2010, at 15:18, André Bisseret wrote:

 Bonjour,
 
 I am trying to get a list field where it would be possible to reorder the 
 lines.
 (is there somewhere any tutorial or any solution on this?)



-- 

official ChatRev page:
http://bjoernke.com?target=chatrev

Chat with other RunRev developers:
go stack URL http://bjoernke.com/chatrev/chatrev1.3b3.rev;

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: How to reorder lines in a list field

2010-10-30 Thread André Bisseret


Thanks a lot Björnke for your prompt reply, and your solution. It  
works well (and very fast ;-)


André

Le 30 oct. 10 à 15:42, Björnke von Gierke a écrit :



I can't help you with code from someone else that I have no  
intention of looking at. Most likely a mouseenter or mouseleave  
doesn't trigger, no clue. For reordering lines, there's no build in  
way, and there are many possible ways to do it. Here's mine. It uses  
just the list field, and is probably a bit simplistic (no floating  
line/drag image following the mouse cursor). But it works for a  
single selection list field.


on mousedown
put the selectedText of me into myDrag
put the mouseLine into mySelection
repeat while the mouse is down
  put the mouseLine into toSelect
  if mySelection  toSelect and toSelect   then
put the scroll of me into theScroll
put me into theText
put word 2 of toSelect into LinetoSelect
if lineToSelect = the number of lines of me then
  delete line (word 2 of mySelection) of theText
  put return  myDrag after line -1 of theText
else
  delete line (word 2 of mySelection) of theText
  put myDrag  return before line lineToSelect of theText
end if
put toSelect into mySelection
lock screen
put theText into me
set the scroll of me to theScroll
select line (word 2 of myselection) of me
unlock screen
  end if
end repeat
showSettings
end mouseDown


On 30 Oct 2010, at 15:18, André Bisseret wrote:


Bonjour,

I am trying to get a list field where it would be possible to  
reorder the lines.

(is there somewhere any tutorial or any solution on this?)




--

official ChatRev page:
http://bjoernke.com?target=chatrev

Chat with other RunRev developers:
go stack URL http://bjoernke.com/chatrev/chatrev1.3b3.rev;

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your  
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-revolution
---
Orange vous informe que cet  e-mail a ete controle par l'anti-virus  
mail.

Aucun virus connu a ce jour par nos services n'a ete detecte.






___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re; Stress-testing SQLite

2010-10-30 Thread Richard Gaskin

Sivakatirswami wrote:


I was using and old example SQL stack... small data returns were fast,
but a lot of data (select * from table whatever.. i.e. everything)
from a PostGreSQL database  adding it to a display field. It took
forever...

Then I remembered Dont' Do That!

When I got all the data in a variable and just posted to the field once,
it was like 20 times faster.


It seems in my initial tests that the time it takes to get data through 
the externals interface is much long than what it takes to move data 
around within Rev natively.


Is this a known limitation of externals, or is this just a case of false 
attribution of the root cause on my part?


--
 Richard Gaskin
 Fourth World
 LiveCode training and consulting: http://www.fourthworld.com
 Webzine for LiveCode developers: http://www.LiveCodeJournal.com
 LiveCode Journal blog: http://LiveCodejournal.com/blog.irv
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: How to reorder lines in a list field

2010-10-30 Thread Scott Rossi
Recently, André Bisseret wrote:

 I am trying to get a list field where it would be possible to reorder
 the lines.
 (is there somewhere any tutorial or any solution on this?)

GetInLine is one example.  Execute in your message box:

go URL http://www.tactilemedia.com/site_files/downloads/getinline.rev;

Regards,

Scott Rossi
Creative Director
Tactile Media, UX Design


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


RE: Stress-testing SQLite

2010-10-30 Thread Lynn Fredricks
 many of the data stores for the major apple apps use sqlite. 
 it's a petty robust single user data store. 

Of course I don't need to expand on what Ruslan will say about Valentina,
but I will say that there's a right tool for each job, and others that sort
of work but aren't optimal. I can use a brick or the butt of a screwdriver
to drive a nail into a piece of wood. There are reasons why, for example,
AOL Europe, Nikon Corporation and others that may not be named chose
Valentina over something like SQLite for their specific projects. 

I can say for certain that developers do not pick Valentina because it is
free or in public domain :-)

SQLite is a functional, single user database, but the database market is
filled with alternatives. Its worth looking at Ruslan's emails recently
asking about changing schema to see where even his expectations for SQLite
were different.

SQLite has its place in development, and there are good reasons to use it.
But like evaluating any infrastructure technology, you have to consider what
your long term plans are and what your clients are likely to ask for later.

Best regards,

Lynn Fredricks
President
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


RE: Stress-testing SQLite

2010-10-30 Thread Lynn Fredricks
 32TB db limit according to this:
 
 http://en.wikipedia.org/wiki/Comparison_of_relational_database
 _management_systems#Limits

Charts like this, especially on Wikipedia should be taken with a grain of
salt. Feature comparisions (yes/no) I can appreciate, but when it comes to
capacity and performance, that's a bit different. There are some database
vendors that in their EULAs state you cannot publish performance data, and
also have sued some who have done so. 

My advice if you are considering entering a software product market that is
as mature as the database market - save yourself the hair loss and choose
another ;-)

In all fairness to all the databases in that list (Valentina can act like a
relational database, but it isnt there because it's a columnar database),
for many of them, the limits are theoretical and based on limitations of how
volumes work in file systems and operating systems.

Best regards,

Lynn Fredricks
President
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Stress-testing SQLite

2010-10-30 Thread Richard Gaskin

Lynn Fredricks wrote:


32TB db limit according to this:

http://en.wikipedia.org/wiki/Comparison_of_relational_database
_management_systems#Limits


Charts like this, especially on Wikipedia should be taken with a grain of
salt. Feature comparisions (yes/no) I can appreciate, but when it comes to
capacity and performance, that's a bit different.


Indeed.  With LiveCode, for example, fields can *theoretically* hold up 
to 4GB, but I pity the person who tries it.


There's often a vast difference between theoretical addressing limits 
and real-world use, hence my interest in finding actual use cases for 
SQLite.



There are some database vendors that in their EULAs state you cannot
publish performance data, and also have sued some who have done so.


A curious limitation.  Which ones?

--
 Richard Gaskin
 Fourth World
 LiveCode training and consulting: http://www.fourthworld.com
 Webzine for LiveCode developers: http://www.LiveCodeJournal.com
 LiveCode Journal blog: http://LiveCodejournal.com/blog.irv
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: How to reorder lines in a list field

2010-10-30 Thread FlexibleLearning
A very nice handler, BvG!

As written it needs the traversalON to be true to display correctly. A minor
change to one line and it displays correctly whether the traversalON is
either true or false...

on mousedown
  put the selectedText of me into myDrag
  put the mouseLine into mySelection
  repeat while the mouse is down
put the mouseLine into toSelect
if mySelection  toSelect and toSelect   then
  put the scroll of me into theScroll
  put me into theText
  put word 2 of toSelect into LinetoSelect
  if lineToSelect = the number of lines of me then
delete line (word 2 of mySelection) of theText
put return  myDrag after line -1 of theText
  else
delete line (word 2 of mySelection) of theText
put myDrag  return before line lineToSelect of theText
  end if
  put toSelect into mySelection
  lock screen
  put theText into me
  set the scroll of me to theScroll
  # select line (word 2 of myselection) of me
  set the hilitedLines of me to (word 2 of myselection)
  unlock screen
end if
  end repeat
end mouseDown

Hugh Senior
FLCo

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


RE: Stress-testing SQLite

2010-10-30 Thread Lynn Fredricks
  There are some database vendors that in their EULAs state 
 you cannot 
  publish performance data, and also have sued some who have done so.
 
 A curious limitation.  Which ones?

A bad Halloween joke first:

Q: Where do vampires learn to suck blood?

A: Law school.

Without naming names, Ones with a Really Awesome, Conniving Legal
Environments have been known to include such things.

Best regards,

Lynn Fredricks
President
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: How to reorder lines in a list field

2010-10-30 Thread André Bisseret


Le 30 oct. 10 à 17:49, Scott Rossi a écrit :



Recently, André Bisseret wrote:


I am trying to get a list field where it would be possible to reorder
the lines.
(is there somewhere any tutorial or any solution on this?)


GetInLine is one example.  Execute in your message box:

go URL http://www.tactilemedia.com/site_files/downloads/ 
getinline.rev


Regards,

Scott Rossi
Creative Director
Tactile Media, UX Design


Thanks Scott for your reply.

Indeed, I know your very nice GetInLine (which was pointed out by  
Éric Chatonet in his tutorial Managing Drag and Drop


But, actually, I am trying to learn using the drag and drop features  
of livecode.


In fact starting from this tutorial, I have got a script which runs  
nicely in a test stack I made.


My problem arises when I put the same script in a field of an app. I  
am developping:  it does not works there.

Even If I copy the test field on my app. it does not work.

If I copy the field of my app. (which has the same script) on a brand  
new stack, then the script works!!


So the problem comes from the stack of my app.

I can't find any idea about what  could hinder the field and its  
script when it is on my app.


Thanks again for your reply

Best regards

André





___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: the siglum key ???

2010-10-30 Thread Richmond

On 10/30/2010 04:42 PM, Mike Bonner wrote:

This might be useful, or discouraging.

http://support.apple.com/kb/HT2841


Obviously designed for chaps with better eyesight than mine.

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Best practice for creating a custom control

2010-10-30 Thread Jérôme Rosat
Hi Mark,

Thank you for the link and the example.

I note that you reach the data of the field through a setProp and a get Prop 
handler. 

Best regards,

Jerome

Le 30 oct. 2010 à 01:28, Mark Schonewille a écrit :

 Hi Jerome,
 
 You might want to have a look at the scripts of the password field, available 
 at http://qurl.tk/jo
 
 --
 Best regards,
 
 Mark Schonewille
 
 Economy-x-Talk Consulting and Software Engineering
 Homepage: http://economy-x-talk.com
 Twitter: http://twitter.com/xtalkprogrammer
 KvK: 50277553
 
 Download the Installer Maker plugin for Runtime Revolution at 
 http://qurl.tk/ce Create installers for Mac and Windows on *every* 
 Rev-compatible platform. No additional software needed.
 
 On 30 okt 2010, at 01:14, Jérôme Rosat wrote:
 
 Hello everybody,
 
 I'm looking for a kind of best practice for creating custom controls. For 
 example, how to access the data of the custom control ? Do we have to use 
 custom properties or a setProp or getProp handlers  or both ? Is it 
 preferable to use a prefix for naming a command ? And for custom properties, 
 do we have to use a set of properties ? With a standard name ? Etc.
 
 Thank you for you help.
 
 Jerome
 
 ___
 use-revolution mailing list
 use-revolution@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-revolution

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Stress-testing SQLite -- millions records? Use Valentina DB

2010-10-30 Thread stephen barncard
Yes, I've been waiting for Ruslan to chime in here.   Valentina has been the
*elephant in the room* in this discussion and I find it slightly odd that
Richard (no newbie in the Rev world) hadn't considered this product for his
project.

If I were starting a new db project right now and wasn't forced into mySQL
by the client, I would take a serious look at the Valentina  ADK.

Right now they are offering the beta of Valentina Studio Pro for free ( and
there's a free Valentina Linux server for non-commercial use - Richmond?)

geesh, I just talked myself into finally trying this product myself.

I don't see any other db company bending over backward to serve Rev/Livecode
users.   And we even have Ruslan on the list here


On 29 October 2010 23:28, Ruslan Zasukhin
ruslan_zasuk...@valentina-db.comwrote:

 On 10/30/10 3:17 AM, Richard Gaskin ambassa...@fourthworld.com wrote:

 Hi Richard,

  I have a need coming up for a data store that can robustly handle at
  least a million records, ideally up to five million, where each record
  may be as large as 5k.
 
  I don't need relationality, so for me SQLite is an option but only an
  option; I'm happy to consider other options as well. (Yes, it has to be
  SQLite rather than MySQL, because it needs to work embedded with a
  commercial application).

 Valentina DB is faster 100 times of SqlLite, mySQL

 And can be perfectly embedded into commercial application because it is
 royalty free.


  Have any of you done stress testing on SQLite to that degree?
 
  I've tried finding even anecdotal data on the web for SQLite limits, and
  while I can find citations of theoretical limits I haven't come across
  real-world usage stories of data sets that large.
 
  Should I be confident in SQLite as a storage solution for that?  Should
  I be scared?

 SCARED :)

  Thanks in advance for sharing your experiences with large data sets if
  SQLite.

 You need Valentina DB.

 Okay you need 5K for each record.
 How many fields?

 Let me remind that Valentina has columnar format.
 This is huge advantage.

 Also Valentina can give you not only SQL way but NON-SQL way,
 Which can be additionally 10-20 times faster!

 --
 I can tell you store, that Valentina was tested for AOL Europe by their dev
 team. Against Berkly,  mySQL, postgre, and other dbs. SqlLite even was not
 in game of course.

 Task was so simple. Table has 2 fields {URL, PictureBannerAd }

 So when somebody ask for a WEB page, it needs find banner to be shown.

 As they told, e.g. Berkly have give 100 faults per time (min our hour I not
 remember now).  Other dbs also. Fault means that banner was not found  by
 DB
 in time less of timeout.

 Valentina have give them zero faults.


 Let me underline this very important feature NON-SQL-ness of Valentina.
 As well as very powerful SQL.

 Today is very modern stream talk about how SQL DBs are bad, and how cool
 are
 NON-SQL with Key-Value.  Guys, be happy, Valentina is perfect for both
 tasks. :-)

 If talk about details, in V4REV API (and most others Valentina ADKs) you
 can
 use not SQL way to do searches and sortngs using
   VField_FindValue()
   VField_FindRange()
   VField_FindLike()

 And other similar search methods.  They are really FASTEST POSIBLE way.


 --
 Best regards,

 Ruslan Zasukhin
 VP Engineering and New Technology
 Paradigma Software, Inc

 Valentina - Joining Worlds of Information
 http://www.paradigmasoft.com

 [I feel the need: the need for speed]


 ___
 use-revolution mailing list
 use-revolution@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-revolution




-- 



Stephen Barncard
San Francisco Ca. USA

more about sqb  http://www.google.com/profiles/sbarncar
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Stress-testing SQLite

2010-10-30 Thread Mark Wieder
Lynn-

Saturday, October 30, 2010, 11:15:48 AM, you wrote:

 Without naming names, Ones with a Really Awesome, Conniving Legal
 Environments have been known to include such things.

Sounds a bit of an urban legend. I just checked my license (granted
it's only version 8.0.5, but...) and there's nothing like that.

-- 
-Mark Wieder
 mwie...@ahsoftware.net

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


RE: Stress-testing SQLite

2010-10-30 Thread Lynn Fredricks
  Without naming names, Ones with a Really Awesome, Conniving Legal 
  Environments have been known to include such things.
 
 Sounds a bit of an urban legend. I just checked my license 
 (granted it's only version 8.0.5, but...) and there's nothing 
 like that.

It was big news a few years ago when they sued someone for posting
benchmarks (I believe comparing with DB2 and a few others). Im sure you can
find article bits if you search.

Best regards,

Lynn Fredricks
President
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Re; Stress-testing SQLite

2010-10-30 Thread Monte Goulding

Could you post some of your results here Richard. 

Sent from my iPad

On 31/10/2010, at 2:23 AM, Richard Gaskin ambassa...@fourthworld.com wrote:
 
 It seems in my initial tests that the time it takes to get data through the 
 externals interface is much long than what it takes to move data around 
 within Rev natively.
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Stress-testing SQLite

2010-10-30 Thread Monte Goulding

On 31/10/2010, at 4:55 AM, Richard Gaskin ambassa...@fourthworld.com wrote:

 Lynn Fredricks wrote:
 
 32TB db limit according to this:
 
 http://en.wikipedia.org/wiki/Comparison_of_relational_database
 _management_systems#Limits
 
 Charts like this, especially on Wikipedia should be taken with a grain of
 salt. Feature comparisions (yes/no) I can appreciate, but when it comes to
 capacity and performance, that's a bit different.
 
 Indeed.  With LiveCode, for example, fields can *theoretically* hold up to 
 4GB, but I pity the person who tries it.

My point was that given your expected max db size of 5kB * 500 is 23GB this 
is only a very small fraction of the stated theoretical limits of SQLite. 

Cheers

Monte___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: How to reorder lines in a list field

2010-10-30 Thread Wilhelm Sanke

Check out

http://www.sanke.org/Software/DragWithListFields.zip

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Stress-testing SQLite

2010-10-30 Thread Richard Gaskin

Interesting find:

  The Truth About the TPC
  ...
  For example, one reader asked, Why does the TPC organization
  only test commercially licensed operating systems and databases?
  My presumptions would lead me to think that a non-profit based
  organization would be benchmarking anything they could get their
  hands on. An example being, why don't they test postreqsql or
  mysql on a Linux platform?
  ...
  However, the TPC doesn't have the power to run benchmark tests
  on a database platform without the approval of the database
  vendor. In fact, with the exception of IBM, most major database
  vendors include in their license agreements a clause that forbids
  the publication of benchmark information without explicit
  permission. Here's the clause from the SQL Server End User
  License Agreement (EULA):

 e. Benchmark Testing. You may not disclose the results of
 any benchmark test of either the Server Software or Client
 Software to any third party without Microsoft's prior
 written approval.

  Oracle, Sybase, and Informix each have a similar clause. These
  clauses are generically referred to as DeWitt clauses. David
  DeWitt was one of the founders of the Wisconsin Benchmarks,
  which were first published in the mid-1980s. At that time, the
  Wisconsin Benchmarks published less-than-favorable scores for an
  Oracle database, and Oracle wasn't happy with the negative
  publicity. Oracle added a clause to its license agreement
  forbidding unauthorized benchmarking, and most other vendors
  followed suit.
  ...

http://www.sqlmag.com/article/benchmarks/the-truth-about-the-tpc.aspx


--
 Richard Gaskin
 Fourth World
 LiveCode training and consulting: http://www.fourthworld.com
 Webzine for LiveCode developers: http://www.LiveCodeJournal.com
 LiveCode Journal blog: http://LiveCodejournal.com/blog.irv
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Escape key doesn't work with fullScreen?

2010-10-30 Thread Richard Gaskin


While testing a presentation stack I noticed that the escapeKey message 
doesn't seem to be sent while the stack is in fullscreen mode, though it 
works as expected otherwise.


Is this a known feature/issue?

Or am I doing something wrong?

--
 Richard Gaskin
 Fourth World
 LiveCode training and consulting: http://www.fourthworld.com
 Webzine for LiveCode developers: http://www.LiveCodeJournal.com
 LiveCode Journal blog: http://LiveCodejournal.com/blog.irv
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Stress-testing SQLite

2010-10-30 Thread Mark Wieder
Richard-

http://www.informationweek.com/news/software/linux/showArticle.jhtml?articleID=201001901

-- 
-Mark Wieder
 mwie...@ahsoftware.net

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


[OT] Browsing the internet... It is safer from Linux?

2010-10-30 Thread Alejandro Tejada
Hi All,

Recently I have been considering seriously to unplug all
my Windows computers from the internet and
use only Linux to browse and download updates.

In truth,
How safe is using Linux browsers in the internet?
Most exploits seems directed to Windows and Mac users
but are Linux users really exempt from these risks???

What are your first hand experiences with the most common
security risks under the Linux platform?

http://www.owasp.org/index.php/Main_Page
http://e-articles.info/e/a/title/Which-Are-The-Most-Common-Network-Security-Risks/
http://www.bangkokpost.com/tech/technews/34952/today-10-most-common-security-threats-on-the-net
http://www.brighthub.com/internet/security-privacy/articles/3438.aspx

Thanks in advance!

Alejandro
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


RE: Stress-testing SQLite

2010-10-30 Thread Lynn Fredricks
  Indeed.  With LiveCode, for example, fields can 
 *theoretically* hold up to 4GB, but I pity the person who tries it.
 
 My point was that given your expected max db size of 5kB * 
 500 is 23GB this is only a very small fraction of the 
 stated theoretical limits of SQLite.

I have a feeling that the lists on wikipedia, since they come from
difference sources, are a mix of theoretical limits and also limits that
have been tested against differing criteria, but you can't really tell which
is which.

Best regards,

Lynn Fredricks
President
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


RE: Stress-testing SQLite

2010-10-30 Thread Lynn Fredricks
Oracle, Sybase, and Informix each have a similar clause. These
clauses are generically referred to as DeWitt clauses. David
DeWitt was one of the founders of the Wisconsin Benchmarks,
which were first published in the mid-1980s. At that time, the
Wisconsin Benchmarks published less-than-favorable scores for an
Oracle database, and Oracle wasn't happy with the negative
publicity. Oracle added a clause to its license agreement
forbidding unauthorized benchmarking, and most other vendors
followed suit.
...
 
 http://www.sqlmag.com/article/benchmarks/the-truth-about-the-
 tpc.aspx

Indeed, very interesting - this came onto my radar when it was reported that
one of the companies sued someone for doing a comparision of the big iron
databases.

Oracle, IBM and MS are big money players with massive legal departments and
super huge budgets for their products. You'd think they'd simply kill off
smaller companies, leaving only themselves and open source databases. But
the only ones really killed off are those that do not have any really
differentiating value. For us, I think half of the picture is performance,
the other half is platform and extended value support.

Best regards,

Lynn Fredricks
President
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


RE: Stress-testing SQLite -- millions records? Use Valentina DB

2010-10-30 Thread Lynn Fredricks
 Right now they are offering the beta of Valentina Studio Pro 
 for free ( and there's a free Valentina Linux server for 
 non-commercial use - Richmond?)
 
 geesh, I just talked myself into finally trying this product myself.
 
 I don't see any other db company bending over backward to 
 serve Rev/Livecode
 users.   And we even have Ruslan on the list here

Thanks for pointing that out, Stephen. Most DB companies don't show that
much interest in working with IDE vendors (except for themselves when they
also sell and IDE product). We've been very open about working with other
vendors. Runtime has always been really great about partnering.

Best regards,

Lynn Fredricks
President
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


RE: Stress-testing SQLite

2010-10-30 Thread Lynn Fredricks
 http://www.informationweek.com/news/software/linux/showArticle
 .jhtml?articleID=201001901

That's an interesting benchmark, I wish I had a couple of $60K to $75K
server boxes handy so we could see how Valentina would do. We've always
emphasized what can be done with modest hardware specs.

Best regards,

Lynn Fredricks
President
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: [OT] Browsing the internet... It is safer from Linux?

2010-10-30 Thread stephen barncard
Alejandro , When did you last hear about a Mac virus?

I don't like to boast, but..

I practice safe computing and a good router and don't use any anti-virus
software at all on any of my 4 macs. Haven't had a virus problem since 2002.
All running Leopard. Am I being foolish?

I find the need for the annoying McCaffe software when I've used XP quite
disgusting. If the OS is so bad you have to use a third party app to
'protect' yourself

The symbiotic relationship between McCaffee and Microsoft is kinda creepy.
There's even a button I did not install that goes to their website imbedded
in IE 6.

Downloads are almost always easy fast and safe on macs


On 30 October 2010 14:25, Alejandro Tejada capellan2...@gmail.com wrote:

 Hi All,

 Recently I have been considering seriously to unplug all
 my Windows computers from the internet and
 use only Linux to browse and download updates.

 In truth,
 How safe is using Linux browsers in the internet?
 Most exploits seems directed to Windows and Mac users
 but are Linux users really exempt from these risks???

 What are your first hand experiences with the most common
 security risks under the Linux platform?

 http://www.owasp.org/index.php/Main_Page

 http://e-articles.info/e/a/title/Which-Are-The-Most-Common-Network-Security-Risks/

 http://www.bangkokpost.com/tech/technews/34952/today-10-most-common-security-threats-on-the-net
 http://www.brighthub.com/internet/security-privacy/articles/3438.aspx

 Thanks in advance!

 Alejandro
 ___
 use-revolution mailing list
 use-revolution@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-revolution




-- 



Stephen Barncard
San Francisco Ca. USA

more about sqb  http://www.google.com/profiles/sbarncar
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


benchmarks

2010-10-30 Thread Mark Wieder
Lynn-

Saturday, October 30, 2010, 1:54:18 PM, you wrote:

 It was big news a few years ago when they sued someone for posting
 benchmarks (I believe comparing with DB2 and a few others). Im sure you can
 find article bits if you search.

Actually, no. You no doubt have better searching ability than I do.
All I've been able to come up with are many comparison benchmarks with
various results. I have a healty distrust of benchmarks in general.

And the Center for Internet Security has benchmarks available from
their website, as well as a benchmarking tool for members to let you
roll your own.

http://cisecurity.org/en-us/?route=downloads.multiform

-- 
-Mark Wieder
 mwie...@ahsoftware.net

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: [OT] Browsing the internet... It is safer from Linux?

2010-10-30 Thread Mike Bonner
If you're only wanting to browse, and are not sure a particular site
can be trusted, you might try using a live linux cd and browse from
there.  Might not hurt to unmount your hard drive partition if you do
this just as an added layer of protection. Some live cd's auto mount
what they can find, some don't.

I run clamXav on my mac just because i was curious, but have never
found anything with it.

As far as downloading updates with linux, if you download something
with a trojan, and transfer it to your windows machine, you can still
get nailed unless your windows AV or malware scanner picks it up.  In
many cases it boils down to whether you believe the site you are
downloading from can be trusted or not.

I ran windows for a lot of years and didn't have too much trouble. Was
surely not trouble free by any means.  In some ways, I think its worse
now.  Cross session hijacking, clickjacking, browser exploits.  With
things moving closer and closer to being cloud based, I suspect things
are going to get really really ugly before they get better.  Just my
opinion though.



On 10/30/10, stephen barncard stephenrevoluti...@barncard.com wrote:
 Alejandro , When did you last hear about a Mac virus?

 I don't like to boast, but..

 I practice safe computing and a good router and don't use any anti-virus
 software at all on any of my 4 macs. Haven't had a virus problem since 2002.
 All running Leopard. Am I being foolish?

 I find the need for the annoying McCaffe software when I've used XP quite
 disgusting. If the OS is so bad you have to use a third party app to
 'protect' yourself

 The symbiotic relationship between McCaffee and Microsoft is kinda creepy.
 There's even a button I did not install that goes to their website imbedded
 in IE 6.

 Downloads are almost always easy fast and safe on macs


 On 30 October 2010 14:25, Alejandro Tejada capellan2...@gmail.com wrote:

 Hi All,

 Recently I have been considering seriously to unplug all
 my Windows computers from the internet and
 use only Linux to browse and download updates.

 In truth,
 How safe is using Linux browsers in the internet?
 Most exploits seems directed to Windows and Mac users
 but are Linux users really exempt from these risks???

 What are your first hand experiences with the most common
 security risks under the Linux platform?

 http://www.owasp.org/index.php/Main_Page

 http://e-articles.info/e/a/title/Which-Are-The-Most-Common-Network-Security-Risks/

 http://www.bangkokpost.com/tech/technews/34952/today-10-most-common-security-threats-on-the-net
 http://www.brighthub.com/internet/security-privacy/articles/3438.aspx

 Thanks in advance!

 Alejandro
 ___
 use-revolution mailing list
 use-revolution@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-revolution




 --



 Stephen Barncard
 San Francisco Ca. USA

 more about sqb  http://www.google.com/profiles/sbarncar
 ___
 use-revolution mailing list
 use-revolution@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-revolution

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


RE: benchmarks

2010-10-30 Thread Lynn Fredricks
Hi Mark,

I can't find the article now - doing a search on the company name + various
key words brings up loads and loads of their lawsuit vs Google and not much
else. I recall reading about it when it was news, which could easily have
been in 2006 when DeWitt was such a hot topic.

I did find an interesting article on DeWitt clauses though - focusing on the
tech world but a surprising number of them outside of it:

http://www.allbusiness.com/technology/computer-software/4092403-1.html

 And the Center for Internet Security has benchmarks available 
 from their website, as well as a benchmarking tool for 
 members to let you roll your own.
 
 http://cisecurity.org/en-us/?route=downloads.multiform

Do you know if these benchmarks are for more than (just) security?

Best regards,

Lynn Fredricks
President
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Swapping scrolling text for regular text

2010-10-30 Thread Mark Smith

I have a sort of dumb question. I have a stack with about 12 cards that has a
text field on it (part of a background group). I would like to change this
field to a scrolling text field. Is it possible to swap or change the
existing regular text field into a scrolling one without loosing the
existing text entries? (or is the only option to restart from scratch).

Thanks

-- Mark

-- 
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/Swapping-scrolling-text-for-regular-text-tp3020802p3020802.html
Sent from the Revolution - User mailing list archive at Nabble.com.
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Swapping scrolling text for regular text

2010-10-30 Thread Terry Judd
Mark - all you need to do is select the field and enable its vScrollbar
property in the property inspector.

Regards,

Terry...


On 31/10/10 1:33 PM, Mark Smith mark_sm...@cpe.umanitoba.ca wrote:

 
 I have a sort of dumb question. I have a stack with about 12 cards that has a
 text field on it (part of a background group). I would like to change this
 field to a scrolling text field. Is it possible to swap or change the
 existing regular text field into a scrolling one without loosing the
 existing text entries? (or is the only option to restart from scratch).
 
 Thanks
 
 -- Mark

--
Dr Terry Judd | Senior Lecturer in Medical Education
Medical Education Unit
Melbourne Medical School
The University of Melbourne


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: benchmarks

2010-10-30 Thread Mark Wieder
Lynn-

Saturday, October 30, 2010, 3:20:34 PM, you wrote:

 I did find an interesting article on DeWitt clauses though - focusing on the
 tech world but a surprising number of them outside of it:

 http://www.allbusiness.com/technology/computer-software/4092403-1.html

Thanks. That is indeed an interesting read, extending to the
enforceability of EULA contents in general. On page 6 there's a
reference to saber-brandishing by Microsoft, but not actual legal
actions. And in the conclusion is the statement

There is an excellent possibility, as discussed in section IV.B, that
a court would apply the doctrine of copyright misuse and rule DeWitt
Clauses unenforceable. (section IVB deals in part with the Disney
court's decision that fair use allows criticism regardless of license
restrictions).

 Do you know if these benchmarks are for more than (just) security?

Looking at it again, no, I'm not at all sure. Ignore that one - it's
probably just a red herring.

-- 
-Mark Wieder
 mwie...@ahsoftware.net

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution