Refactoring is your friend / moving from 6.x to 9.x

Peter Bogdanoff bogdanoff at me.com
Tue Jan 1 04:37:46 CET 2019


Is what you mean by creating a memory database as covered in this tutorial?

http://lessons.livecode.com/m/4069/l/565718-how-to-create-and-use-an-sqlite-database <http://lessons.livecode.com/m/4069/l/565718-how-to-create-and-use-an-sqlite-database>

Peter


> On Dec 31, 2018, at 5:16 PM, Ralph DiMola via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> A SQLite memory database is the same as a SQLite file database except it's
> created for just the instance that app is running. You have to create
> table(s) and field(s) for those table(s). Then the app then populates the
> data and queries it. SQLite memory database supports the same SQL syntax as
> a file based SQLite database. When opening an SQLite database if you don't
> supply a file spec then it's created in memory( I think that ":memory:" for
> the file spec also works). If you supply a file spec and the db does not
> exist then an empty one is created just like a memory database. Of course a
> memory database is faster than a disk based database. I find that SQL
> invaluable for dealing with complex data relationships.
> 
> Ralph DiMola
> IT Director
> Evergreen Information Services
> rdimola at evergreeninfo.net
> 
> -----Original Message-----
> From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
> Of J. Landman Gay via use-livecode
> Sent: Monday, December 31, 2018 4:32 PM
> To: How to use LiveCode
> Cc: J. Landman Gay
> Subject: Re: Refactoring is your friend / moving from 6.x to 9.x
> 
> I'm generally deficient when it comes to databases but curious how one
> creates a memory based one. Is there a trick, and does it work with others
> besides sql?
> 
> This is probably a newbie question.
> --
> Jacqueline Landman Gay | jacque at hyperactivesw.com HyperActive Software |
> http://www.hyperactivesw.com On December 31, 2018 11:31:15 AM Bob Sneidar
> via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
>> For multiple recursions into an array I came up with a method for 
>> loading an array into a memory based sql database. Subsequent queries 
>> take less time, depending of course on how complex they are, but you 
>> can do lots of cool thinks, like complex filtering / sorts, 
>> calculations, etc. to a cursor, then I have a function that converts a
> cursor to an array.
>> 
>> I originally used it to get the topmost, leftmost, bottommost and 
>> rightmost objects on a card that were visible by using min and max 
>> queries on a list of the objects. But of course the method can be expanded
> to do almost anything.
>> 
>> Bob S
>> 
>> 
>>> On Dec 30, 2018, at 11:33 , Malte Pfaff-Brill via use-livecode 
>>> <use-livecode at lists.runrev.com> wrote:
>>> 
>>> Not yet fixable for me:
>>> Array operations on larger data sets still slower than they were
>>> 
>>> Non engine related:
>>> My SQL-Fu has improved a bit ;-) Quite a bit of performance to gain
> there.
>>> 
>>> Did anybody of you happen to refactor old code and if so, do you have 
>>> any observations you might want to share?
>>> 
>>> Cheers,
>>> 
>>> Malte
>> 
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



More information about the use-livecode mailing list