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

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

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

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:

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

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

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

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

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

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

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

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:

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

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

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

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

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

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

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

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

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

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

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

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,

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

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

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

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

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

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:

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

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

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

[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

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

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

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

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

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

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

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,

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

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

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

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