Re: changes to the runrev store
And check your charts. The chart in the store page is not the same than the chart in the get started page. Could you also explain your upgrade/update policy because it's hard to find something on site ? Thank you in advance. Jerome Le 18 août 2012 à 11:22, Kevin Miller ke...@runrev.com a écrit : Nothing has changed in the new store for existing customers, for any license type. The same pricing and upgrade policy applies. New customer continue to have access to all the same commercial licenses/upgrades plus new easy pay as you go options. We'll work on making the information clearer. Kind regards, Kevin ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: How to switch two popovers ?
Thomas, Thank you so much for this stack. It helps me a lot. I do not need more, I'm going to move forward in my project. Thank you again. Jerome Jerome, I just created a very crude example. It is just to prove that nested scrolling groups could be put into other scrolling groups and that the nested could be restrained to vertical scrolling and the main group could be restrained to horizontal scrolling. This works. Here is the link: https://www.dropbox.com/s/ds1lpbhfctyvuji/NestedPopOver.livecode Now to make this work for you I would put a UINavBar at the top inside of the main group to script scroll left to right and back again. Then I would further the nested scrolling group script to make scrolling work from within the text field as well as the back ground (try passing mousedown maybe). (check out the options field which does that on its own.) Then I would make a separate little popover arrow that set itself to the side of the main scrolling group and positioned itself where ever the main car is clicked. I didn't want to do it all for you but rather just show you how it can be done. HTHs Thomas J McGrath III 3mcgr...@comcast.net Lazy River Software http://lazyriver.on-rev.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: How to switch two popovers ?
Thomas, Thank you for your answer. I studied several applications for iPad, such Things or Calendar. In Calendar, to add a new event, a popover appears to enter the title of the event. If you want to change the start and end time, you must point to the corresponding button. At that time, the view is pushed to the left with a new view. Simultaneously the title of the new view appears. Briefly, this behavior is complex. And tools available in LiveCode to recreate this behavior seem not very suitable. This is why I was wondering if anyone had found a solution, because personally I have not enough skill to recreate this behavior. Jerome Le 15 août 2012 à 04:08, Thomas McGrath III 3mcgr...@comcast.net a écrit : Jerome, If it is a small amount of data I would use a group and hide and show it. If it is much more than I would go the next card. There are actually two different things going on. One is should this be done in a popover and if so than it should follow standard popover behavior if not than should this be a card or group that then has it's own popovers for the sub data with a back button. I would study a few apps on the iPad and see which behavior works best for the type of data you are wanting to display and then duplicate that behavior in LC. Just some thoughts, Thomas J McGrath III 3mcgr...@comcast.net Lazy River Software http://lazyriver.on-rev.com On Aug 14, 2012, at 12:39 PM, Jérôme Rosat jro...@mac.com wrote: Hi all, I'm developing an application for iPad for my own use. For selecting data, I want to use a popover view and a second popover view for the sub data. I imagine creating two groups, one for each popover. What is the best practice to switch a popover view to another: - Use two cards, each card containing a popover (group) ? - Display the second group simultaneously hiding the first ? - Move within a group, both groups from the right to the left ? - Another solution ? Thank you in advance for your suggestions. Jerome ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
How to switch two popovers ?
Hi all, I'm developing an application for iPad for my own use. For selecting data, I want to use a popover view and a second popover view for the sub data. I imagine creating two groups, one for each popover. What is the best practice to switch a popover view to another: - Use two cards, each card containing a popover (group) ? - Display the second group simultaneously hiding the first ? - Move within a group, both groups from the right to the left ? - Another solution ? Thank you in advance for your suggestions. Jerome ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Sqlite and performances in LiveCode
Thank you very much Trevor. On my iMac 2.8 GHz Intel Core 2 Duo with LiveCode 5.0.2: Opening movies cursor took 274 milliseconds --- Drawing list took 126 milliseconds --- Really impressive compared to previous results ! Jérôme Le 12 mars 2012 à 15:01, Trevor DeVore a écrit : I've updated the stack to use the new technique. You can download it from the same url. I'm on a faster machine testing but here are the times I get: Opening movies cursor took 150 milliseconds --- Drawing list took 81 milliseconds --- -- Trevor DeVore Blue Mango Learning Systems www.clarify-it.com-www.screensteps.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Sqlite and performances in LiveCode
Trevor, yes I'm going to try. But I think it would be a good idea if you could change your stack in the lesson Displaying Large Amounts of Data to demonstrate the performance of LiveCode. Jérôme Le 8 mars 2012 à 05:19, Trevor DeVore a écrit : Jérôme - you might try something like this in LiveCode. If you set up the data grid like the example stack then you would call SELECT rowid FROM table to get the number of records and a list of ids. Then in GetDataForLine you would execute SELECT * FROM table WHERE rowid=N to fill in the row data that is being displayed. -- Trevor DeVore Blue Mango Learning Systems www.clarify-it.com-www.screensteps.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Sqlite and performances in LiveCode
Thank you Pete for that clarification. Jérôme Le 7 mars 2012 à 17:37, Pete a écrit : I emailed sqlitemanager support re the manage/sql tab performance difference. Mystery solved by the reply: In the Manage panel when you see SELECT * FROM table the real query executed is SELECT rowid FROM table and then a SELECT * FROM table WHERE rowid=N is execute for each visible row of the listbox. In the SQL panel query executed is just what you type On Mar 6, 2012 5:47 PM, Pete p...@mollysrevenge.com wrote: I just noticed that the same vendor that makes SQLiteManager also makes an SQLite server package (cubeSQL) that does implement MVCC. But you're right, it's definitely not there in standard SQLite. An SQLite server sounds interesting though. Pete On Tue, Mar 6, 2012 at 11:35 AM, Bernard Devlin bdrun...@gmail.comwrote: I notice from things discussed on the Valentina list that they recommend using API methods rather than SQL calls, because the former will be faster due to less overhead. So these different ways of interacting with a sqlite database might well represent an application using the sqlite API. Although when I use the Valentina VStudio SQL interface I will still see results being returned in 25 ms, compared to 500 ms going through sql yoga revdb v4rev sql valentina. This is doing a select * from a table with 22k rows (10mb in size). That's not to say that I'm outraged at 500ms. There are other steps one can take to make an interface responsive at these timescales. The Valentina guys are pretty used to comparing Livecode with the other platforms for which they provide Valentina. On 19/12/2010 Ruslan had this to say about Livecode: REALbasic - as I remember -- was very fast, near to C code...so it gives e.g. 5% overhead to pure C engine... Revolution and Director give me x4-x10 overhead I thinkRevolution because all params are packed to strings ... Director because quite complex SDK similar to MS COM ... This conclusion by Ruslan appears to be only in the discussion of calling the Valentina API, therefore one would expect that adding other layers (sql, revdb, etc.) one would see other layers adding their own torpor to the action. Does using explict transation control make any difference with sqlite? It shouldn't matter in a case where the data is only being read. I know on MVCC databases this is still a factor if one has a cursor containing the read data, as such data might still be altered from the cursor and the currency control of the MVCC requires a handle on such data to be able to maintain consistency. I can't see that it would apply to sqlite, and this site confirms that sqlite does not implement MVCC: http://www.sqliteconcepts.org/SI_index.html Bernard On Tue, Mar 6, 2012 at 5:15 PM, Pete p...@mollysrevenge.com wrote: I got the same results on the movies database and even more pronounced differences on a table in one of my own databases with ~48k records in it: SQL tab 0.519secs, Manage tab 0.045 secs, more than a 10-fold difference! Just a straight SELECT * in each case. Pete ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode -- Pete Molly's Revenge http://www.mollysrevenge.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Sqlite and performances in LiveCode
Thank you Kay for your feedback. I didn't realize that SQLiteManager was the King of the speed and I am reassured to see that LiveCode is not so slow compared to other tools. Le 5 mars 2012 à 07:22, Kay C Lan a écrit : No, it's not the same one. Looking at the SQLabs site, SQLabs developed from scratch a brand new ListBox that is able to display an infinite number of rows and columns in just few milliseconds. This is a fundamental base control for the app. They've been optemising their product since 2003, it would be surprising if you can match them on your first try. I did a few tests with FireFox's SQLite Manager and for 50,000 records (11MB) it took 504ms to display in a field that could display ALL records. Testing with LC I could extract the same records in 409ms but to display them all in a field took it out to 917ms. By reducing the number of records displayed to the size of the field, it took 410ms. Clearly LC fields are the limiting factor here. I then noticed that in FireFox, although all the rows could be scrolled down to the bottom, the columns were all truncated. So I then changed my LC field to a 'Basic table object', set the 'Maximum editable columns' to match exactly the number of columns I had, and then set the tab stops so only a small portion of data of each column was displayed - similar to how FireFox truncated it's columns. In this way I was able to display ALL the rows in 491 ms. This may not be as fast as SQLabs, but I think they maybe the speed kings. Compared to another SQLite tool I was able to get LC to perform just as fast, if not a little faster. HTH On Sun, Mar 4, 2012 at 7:12 PM, Jérôme Rosat jro...@mac.com wrote: I don't know if SQLiteManager for Firefox is the same one I use (from SQLabs) but it display all the records in one time (I can scroll all the list). But thank you for the suggestion, If necessary I'm going to display only a part of the records with a next button, even if I don't like very much this approach. Le 4 mars 2012 à 03:37, Kay C Lan a écrit : If the 'SQLiteManager' you refer to is the same one I use with FireFox, in my case it only displays 100 records at a time, you have to click the Next button to see more - so this is a performance trick you can do with LC. Instead of extracting 15 records in one go, and displaying it in a field in one go( which will take a long time) only extract 100 records (which will take significantly less time) and have a Next button, just like SQLIte Manager, to retrieve the next 100 records. If I'm right, the the fact that LC only took 4.4 times longer to display 1500 times more records would suggest that you'll be able to do a lot better with LC HTH ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Sqlite and performances in LiveCode
Your acid test is very interesting. Using sqlite3 directly is one solution to increase performance of LiveCode. And you're right, a response time of less than a second is acceptable from a user's perspective and and limit the number of registration is a way to reach this performance. Le 5 mars 2012 à 08:45, Pete a écrit : I think the acid test here is to use sqlite3 vs Livecode, since sqlite3 is the official command line tool for sqlite and likely to be more efficient than any other browsing tool. I tested a select * from a table with about 48,000 records in it, using a datagrid versus an LC screen that invoked sqlite3, passing it all the necessary parameters, reading the output and displayed it in a scrolling field. I did not do any coded timings but retrieving and displaying the records in an LC datagrid took around 3-4 times longer than in sqlite3. The datagrid was using the dgNumberOfRecords/GetDataForLine techniques outlined in the datagrid manual and there was no data formatting involved. The crazy thing about this is that, using those techniques, I believe the datagrid loads only enough database rows to fill the number of rows that are visible in the datagrid, adding more rows as the user scrolls. So the comparison is really between selecting and displaying all 48,000 rows in sqlite3 vs selecting 48,000 rows and displaying only 11 rows (the number of rows in my datagrid). It's pretty clear that using a datagrid to display large datasets is not a good idea if you want to maximize performance unless you really need the the functionality that a datagrid provides. On the other hand, the original post seemed to indicate that, even though the elapsed time using a datagrid was several times longer than the SQLabs tool, it was still less than a second. While it's interesting to figure out why that should be, I'd guess that a response time of less than a second is acceptable from a user's perspective. Pete On Sun, Mar 4, 2012 at 10:22 PM, Kay C Lan lan.kc.macm...@gmail.com wrote: No, it's not the same one. Looking at the SQLabs site, SQLabs developed from scratch a brand new ListBox that is able to display an infinite number of rows and columns in just few milliseconds. This is a fundamental base control for the app. They've been optemising their product since 2003, it would be surprising if you can match them on your first try. I did a few tests with FireFox's SQLite Manager and for 50,000 records (11MB) it took 504ms to display in a field that could display ALL records. Testing with LC I could extract the same records in 409ms but to display them all in a field took it out to 917ms. By reducing the number of records displayed to the size of the field, it took 410ms. Clearly LC fields are the limiting factor here. I then noticed that in FireFox, although all the rows could be scrolled down to the bottom, the columns were all truncated. So I then changed my LC field to a 'Basic table object', set the 'Maximum editable columns' to match exactly the number of columns I had, and then set the tab stops so only a small portion of data of each column was displayed - similar to how FireFox truncated it's columns. In this way I was able to display ALL the rows in 491 ms. This may not be as fast as SQLabs, but I think they maybe the speed kings. Compared to another SQLite tool I was able to get LC to perform just as fast, if not a little faster. HTH On Sun, Mar 4, 2012 at 7:12 PM, Jérôme Rosat jro...@mac.com wrote: I don't know if SQLiteManager for Firefox is the same one I use (from SQLabs) but it display all the records in one time (I can scroll all the list). But thank you for the suggestion, If necessary I'm going to display only a part of the records with a next button, even if I don't like very much this approach. Le 4 mars 2012 à 03:37, Kay C Lan a écrit : If the 'SQLiteManager' you refer to is the same one I use with FireFox, in my case it only displays 100 records at a time, you have to click the Next button to see more - so this is a performance trick you can do with LC. Instead of extracting 15 records in one go, and displaying it in a field in one go( which will take a long time) only extract 100 records (which will take significantly less time) and have a Next button, just like SQLIte Manager, to retrieve the next 100 records. If I'm right, the the fact that LC only took 4.4 times longer to display 1500 times more records would suggest that you'll be able to do a lot better with LC HTH ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url
Re: Sqlite and performances in LiveCode
Trevor, I use the stack provided here: http://www.bluemangolearning.com/download/revolution/tools/datagrid_databases.zip I don't know if I understand your question, but the code is: put the milliseconds into theStart put revQueryDatabase(sConnID,SELECT * FROM movies) into sCursorID put the milliseconds - theStart into theDuration Log Opening movies cursor took theDuration milliseconds There is only one call revQueryDatabase. Le 5 mars 2012 à 20:00, Trevor DeVore a écrit : On Sat, Mar 3, 2012 at 6:00 PM, Jérôme Rosat jro...@mac.com wrote: This database contains approximately 150,000 records and it increases by about 5,000 records per month. Before beginning, I read the lesson Displaying Large Amounts of Data on the site of RunRev and I did tests with the sample stack and database (50'000 records). I was surprised by the performance of LiveCode. When I use the stack (or the standalone app, the query of all the records takes about 932 milliseconds. But when I use SQLiteManager (an app that I use to manage sqlite files) with the same table, at the same place, the query of all the records takes about 194 milliseconds. Jérôme, What are the exact calls you make in LiveCode during the 932 milliseconds? -- Trevor DeVore Blue Mango Learning Systems www.clarify-it.com-www.screensteps.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Sqlite and performances in LiveCode
No, in LiveCode, it takes 138 milliseconds more to display the result. In SQLiteManager, I don't now how many time it takes to display the result. But visually, it takes about 1 second to query and display the records in LiveCode and it is nearly instantaneous in SQLiteManager. Le 4 mars 2012 à 01:28, Gerry Orkin a écrit : It could be the difference in the time taken to display the returned records? Gerry ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Sqlite and performances in LiveCode
I don't know if SQLiteManager for Firefox is the same one I use (from SQLabs) but it display all the records in one time (I can scroll all the list). But thank you for the suggestion, If necessary I'm going to display only a part of the records with a next button, even if I don't like very much this approach. Le 4 mars 2012 à 03:37, Kay C Lan a écrit : If the 'SQLiteManager' you refer to is the same one I use with FireFox, in my case it only displays 100 records at a time, you have to click the Next button to see more - so this is a performance trick you can do with LC. Instead of extracting 15 records in one go, and displaying it in a field in one go( which will take a long time) only extract 100 records (which will take significantly less time) and have a Next button, just like SQLIte Manager, to retrieve the next 100 records. If I'm right, the the fact that LC only took 4.4 times longer to display 1500 times more records would suggest that you'll be able to do a lot better with LC HTH ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Sqlite and performances in LiveCode
Hi all, I have to create a small application to access an SQLite database. This database contains approximately 150,000 records and it increases by about 5,000 records per month. Before beginning, I read the lesson Displaying Large Amounts of Data on the site of RunRev and I did tests with the sample stack and database (50'000 records). I was surprised by the performance of LiveCode. When I use the stack (or the standalone app, the query of all the records takes about 932 milliseconds. But when I use SQLiteManager (an app that I use to manage sqlite files) with the same table, at the same place, the query of all the records takes about 194 milliseconds. Does LiveCode is less efficient to query databases than others development tools? Do you have any ideas to improve performance? Thank you for your feedback. Jérôme ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
iOS: How to create a transition to a new screen
Hello everyone, In iOS, a table view displays data in rows. In a hierarchical structure, when the user selects a row, a new screen slides from the right with a new table view. At the same time, the title of the navigation bar slides and appears from the right to the center, the back button slides and appears from the center to the left, at a different speed from the table view (it seems). I tried to create this transition with LC but I failed recreate it satisfactorily. Do you have any suggestion to create this transition with LC ? Do you know where we can find the speed of the transition of the screen and of the title of the navigation bar ? Thanks in advance. Jerome ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Your message to use-livecode awaits moderator approval
Bob, Monte, Sorry for that. This is my email address. I wanted to send a message to the list, but I use a wrong email address. But by mistake, I sent the error message in the list. I thought I had managed to remove this message. Please ignore. Jerome Le 15 févr. 2011 à 00:25, Monte Goulding a écrit : On 15/02/2011, at 10:20 AM, Bob Sneidar wrote: Why am I getting this? The bounce says it was resent from jro...@mac.com. I'm a little concerned my Mobile Me mail account has been cracked somehow... It must have been sent to the list because I got it too. Cheers Monte ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Fuzzy text on my iPhone 4 with LiveCode iOS
Hi, I have just created my first application with LiveCode iOS (a kind of calculator). When I test it on my iPhone 4, I notice that the text which is displayed in a field is not sharp. As if the text is fuzzy. I use Helvetica. But, when I use it on a iPhone 3GS or on a iPad, the text looks great. Is it a bug or I missed something ? Thank you for your answers. Jerome ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
