Re: Getting started with databases

2010-09-17 Thread Peter Alcibiades
Sorry, sloppy, I meant tab delimited. I do tend to wrongly say csv and automatically assume that tab delimited will be understood. Peter -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Getting-started-with-databases-tp2540312p2543958.html Sent from

Re: Getting started with databases

2010-09-16 Thread Peter Alcibiades
Bob, are you saying, just the tables...? So why not export the tables as csv? Am I missing something to do with relations? Peter -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Getting-started-with-databases-tp2540312p2542837.html Sent from

Re: Getting started with databases

2010-09-16 Thread Bob Sneidar
? Am I missing something to do with relations? Peter -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Getting-started-with-databases-tp2540312p2542837.html Sent from the Revolution - User mailing list archive at Nabble.com

Re: Getting started with databases

2010-09-16 Thread stephen barncard
.278305.n4.nabble.com/Getting-started-with-databases-tp2540312p2542837.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

Re: Getting started with databases

2010-09-16 Thread Bob Sneidar
Aye, but we were talking about CSV, Comma Separated Values I think is what it stands for. Bob On Sep 16, 2010, at 1:36 PM, stephen barncard wrote: Filemaker tabbed delimited export converts returns to vertical tab characters. You can still retain your returns.

Getting started with databases

2010-09-15 Thread Tim Lambert
Hello I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone recommend any aids memoire or templates or anything to help

Re: Getting started with databases

2010-09-15 Thread Klaus on-rev
Hi Tim, Hello I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone recommend any aids memoire or templates

Re: Getting started with databases

2010-09-15 Thread Monte Goulding
I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone recommend any aids memoire or templates or anything to help

Re: Getting started with databases

2010-09-15 Thread Devin Asay
On Sep 15, 2010, at 4:56 AM, Tim Lambert wrote: Hello I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone

Re: Getting started with databases

2010-09-15 Thread Andre Garzia
: Hello I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone recommend any aids memoire or templates or anything to help

Re: Getting started with databases

2010-09-15 Thread Bob Sneidar
which really take the headaches out of working with SQL. Bob On Sep 15, 2010, at 3:56 AM, Tim Lambert wrote: Hello I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining

Re: Getting started with databases

2010-09-15 Thread Bob Sneidar
Not to dis anyone's product, but it should be plainly stated, unless things have improved, that by Filemaker Databases, the developer means ONLY the Filemaker Databases. If you have scripts, I do not think it imports those, and last time I tried it, forms were also not imported. I'll say

Re: Listing available MYSQL databases

2010-05-29 Thread Ken Ray
Actually, it's even easier than that: put /usr/local/mysql/bin/mysql -u username -p password --execute='show databases' into tCmd put shell(tCmd) The only minor downside is to get the TRUE list, you need to clean up the result a bit (the first line just says Database and the last line is empty

Re: Remote SQL databases

2010-05-25 Thread Bob Sneidar
: I am not a MySQL expert but I have found that it is possible to join different databases, each with various tables. The trick is to use the database name to fully qualify the table and item such as: SELECT db1.table1.item1, db2.table2.item1 FROM db1.table1, db2.table2 WHERE ... Here

Re: Remote SQL databases

2010-05-25 Thread Mark Wieder
Bob- Monday, May 24, 2010, 9:00:59 PM, you wrote: I am not a MySQL expert but I have found that it is possible to join different databases, each with various tables. Bob S.'s main issue here is that he's trying to join two different *types* of databases, a MySQL database and a SQLite

Re: Listing available MYSQL databases

2010-05-25 Thread Joe F.
This script would make promysql evaluate to mysqlshow - u nrl -pnrl1 On May 23, 2010, at 3:36 PM, Glen Bojsza wrote: Hello, Has anyone successfully used either open process or get shell() to list the databases available on a machine. From the command line I do the following and get

Re: Remote SQL databases

2010-05-25 Thread Bob Sneidar
Which is why if I pull this off, there are people who may be interested in it. Bob On May 25, 2010, at 10:19 AM, Mark Wieder wrote: I think the only way around this is to issue two SQL commands, one to MySQL, one to SQLite, then take the recordsets and mangle them yourself, pretending that

Re: Listing available MYSQL databases

2010-05-25 Thread Glen Bojsza
successfully used either open process or get shell() to list the databases available on a machine. From the command line I do the following and get the results I am looking for: [...@localhost ~]$ mysqlshow -u nrl -p Enter password:(I enter

Re: Remote SQL databases

2010-05-25 Thread Trevor DeVore
On May 21, 2010, at 6:31 PM, Bob Sneidar wrote: I'm wondering if the Relational aspect of Trevor's sqlYoga would be able to do this, but again, I think I have to be working with two tables in the same database for that to work. Trevor? That is correct. SQL Yoga will only work with

Re: Listing available MYSQL databases

2010-05-25 Thread Bob Cole
If you put SHOW DATABASES; in a text file on the target machine then you can execute the following statements (watch for line breaks): put /usr/local/mysql/bin/mysql -u username -ppassword '/usr/local/ShowDatabases.txt' into myCommand put shell(myCommand) into message box That works

Re: Remote SQL databases

2010-05-24 Thread Bob Sneidar
Gotcha. Teaches me to take my web guy's word for it. :-) Bob On May 21, 2010, at 5:04 PM, Mark Stuart wrote: Hi Bob, on Fri May 21 17:31:53 CDT 2010, Bob Sneidar wrote: So now I have to think about using joins. Just preface the table name that's in the other database with the

Re: Remote SQL databases

2010-05-24 Thread Bob Sneidar
Hi Mark and all interested parties. Perhaps I failed to mention that the two databases do not know about each other. The SQL server doing the join has no access to the file based SQLite database it is doing a join against. I am pretty sure this is impossible to do like this. It's okay though

Re: Remote SQL databases

2010-05-24 Thread Bob Cole
I am not a MySQL expert but I have found that it is possible to join different databases, each with various tables. The trick is to use the database name to fully qualify the table and item such as: SELECT db1.table1.item1, db2.table2.item1 FROM db1.table1, db2.table2 WHERE ... Here

Re: Remote SQL databases

2010-05-23 Thread Bob Sneidar
Oh hello! You are saying you CAN do a join on a table that is not in the same database? Bob Sneidar IT Manager Calvary Chapel CM Sent from iPhone On May 22, 2010, at 18:35, Mark Wieder mwie...@ahsoftware.net wrote: Mark- Friday, May 21, 2010, 5:04:57 PM, you wrote: SELECT

Re: Remote SQL databases

2010-05-23 Thread Mark Wieder
Bob- Sunday, May 23, 2010, 12:04:03 PM, you wrote: Oh hello! You are saying you CAN do a join on a table that is not in the same database? Well, I haven't tried it, bu Mark S. implied that it was possible with two different aliases... -- -Mark Wieder mwie...@ahsoftware.net

Listing available MYSQL databases

2010-05-23 Thread Glen Bojsza
Hello, Has anyone successfully used either open process or get shell() to list the databases available on a machine. From the command line I do the following and get the results I am looking for: [...@localhost ~]$ mysqlshow -u nrl -p Enter password

Re: Remote SQL databases

2010-05-23 Thread Andre Garzia
I did it on my 6k thousand table database... It works fine for us. I have something like select Database1.* from DatabaseName1.Table1 as Database1, DatabaseName2.Table2 ... On Sun, May 23, 2010 at 4:34 PM, Mark Wieder mwie...@ahsoftware.net wrote: Bob- Sunday, May 23, 2010, 12:04:03 PM,

Re: Remote SQL databases

2010-05-22 Thread Mark Wieder
Mark- Friday, May 21, 2010, 5:04:57 PM, you wrote: SELECT cus.Customer_Number, cus.Customer_Name, ctyp.Customer_Type_Name FROM database1.customers AS cus LEFT OUTER JOIN database2.customer_types as ctyp ON cus.Customer_Type = ctyp.Customer_Type_ID Nice one - someone actually found a use for

Remote SQL databases

2010-05-21 Thread Bob Sneidar
Hi all. Anyone have any idea how fast the queries to the On-Rev SQL databases are on average? I was using a method where I was looking up a key from one query of 100 records at a time and querying a mySql database at my On-Rev site ONE RECORD AT A TIME! I discovered that the queries were

Remote SQL databases

2010-05-21 Thread Mark Stuart
Hi Bob, on Fri May 21 17:31:53 CDT 2010, Bob Sneidar wrote: So now I have to think about using joins. Just preface the table name that's in the other database with the database_alias_name.table_name: SELECT cus.Customer_Number, cus.Customer_Name, ctyp.Customer_Type_Name FROM

Cloud databases and scalability (was Rodeo: 2 questions)

2010-05-20 Thread David Bovill
On 20 May 2010 21:52, Mark Wieder mwie...@ahsoftware.net wrote: Twitter, Digg, Reddit, etc are indeed reaching the scalability limits of their databases, and are moving into the NOSQL world of Cassandra, Hadoop, CouchDB... but you need to up at the level of shoveling around petabytes of data

[ANN] SQL Yoga Now Supports More Databases, Additional Documentation

2009-10-09 Thread Trevor DeVore
Last night a new version of SQL Yoga was uploaded with support for Valentina client and server connections. With the addition of Valentina the list of supported databases is now: * MySQL * PostGreSQL * SQL Server (ODBC) * SQLite * Valentina local and client I recommend using the latest beta

RE: [ANN] SQL Yoga Now Supports More Databases, Additional Documentation

2009-10-09 Thread Lynn Fredricks
Last night a new version of SQL Yoga was uploaded with support for Valentina client and server connections. With the addition of Valentina the list of supported databases is now: * MySQL * PostGreSQL * SQL Server (ODBC) * SQLite * Valentina local and client I recommend using

Re: [ANN] SQL Yoga Now Supports More Databases, Additional Documentation

2009-10-09 Thread Neal Campbell
connections. With the addition of Valentina the list of supported databases is now: * MySQL * PostGreSQL * SQL Server (ODBC) * SQLite * Valentina local and client I recommend using the latest beta of Valentina (4.3) if you are working with Revolution and Valentina. Nice! I

[SIMULCAST/RunRevLive] MultiUser Databases with MySQL

2009-09-02 Thread Andre Garzia
Hi Folks, the files for my session are located at http://andregarzia.on-rev.com/invoice.zip any feedback is appreciated. -- http://www.andregarzia.com All We Do Is Code. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit

[OT] where all the databases go...

2009-04-27 Thread viktoras d.
What does Oracle plan to do with MySQL? Oracle: MySQL will be an addition to Oracle’s existing suite of database products, which already includes Oracle Database 11g, TimesTen, Berkeley DB open source database, and the open source transactional storage engine, InnoDB. --- Berkeley DB

Re: [OT] where all the databases go...

2009-04-27 Thread Bernard Devlin
.) MySQL responded by developing the Falcon engine (using the knowledge of Jim Starkey, who created the InterBase/Firebird line of databases dating back to the early 1980s). Maybe Oracle did actually want some of Sun's other technologies. Or maybe they just wanted to make sure no-one else got MySQL

RE: [OT] where all the databases go...

2009-04-27 Thread Lynn Fredricks
What does Oracle plan to do with MySQL? Oracle: MySQL will be an addition to Oracle's existing suite of database products, which already includes Oracle Database 11g, TimesTen, Berkeley DB open source database, and the open source transactional storage engine, InnoDB. As you can guess,

Re: Large databases kaput?

2009-01-03 Thread Nicolas Cueto
Going out on a limb here... If I understand you correctly -- namely, you're trying to build a stack that has 5000+ cards -- then I think the problem is not Rev's limitations but rather the design you're envisioning for your stack. Perhaps if you described a bit more what you want your stack to

Re: Large databases kaput?

2009-01-03 Thread dunbarx
On Jan 3, 2009, at 3:01:29 AM, Nicolas Cueto nicon...@gmail.com wrote: From: Nicolas Cueto nicon...@gmail.com Subject:Re: Large databases kaput? Date: January 3, 2009 3:01:29 AM EST To: How to use Revolution use-revolution@lists.runrev.com Going out on a limb here... If I understand you

Re: Large databases kaput?

2009-01-03 Thread Björnke von Gierke
The issue is speed of execution for card based operations, like push/ pop, find and so on. Making stacks that have such a big amount of cards is just not fast, even though things will work fine otherwise. On 3 Jan 2009, at 18:05, dunbarx wrote: Thanks for the reply, but not that. I heard on

Re: Large databases kaput?

2009-01-03 Thread J. Landman Gay
dunbarx wrote: Thanks for the reply, but not that. I heard on another thread that there was a Rev issue with large stacks, 5000+ cards. I wanted feedback before I made a test stack to check it out. Is it a matter of navigation, finding stuff, open/close or what? As Bjoernke mentioned, it's

Re: Large databases kaput?

2009-01-03 Thread dunbarx
J... OK, got it. I will cross that bridge when I come to it. Thanks, Craig On Jan 3, 2009, at 1:59:04 PM, J. Landman Gay jac...@hyperactivesw.com wrote: From: J. Landman Gay jac...@hyperactivesw.com Subject:Re: Large databases kaput? Date: January 3, 2009 1:59:04 PM EST To: How

Large databases kaput?

2009-01-02 Thread dunbarx
What? Say it ain't so. Do I understand that there is some practical limit to the number of cards in a stack, that a speed hit is reached at a mere 5000? Where was the warning on the label??? Before I make a stack and test thisanyone? Craig Newman

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-24 Thread Jerry Daniels
William, GLX2 set the default folder, but sets it back again. Perhaps this process was interrupted. I'll double check the code to bullet-proof it. Thanks for the report and detective work. Best, Jerry Daniels Daniels Mara, Inc. Makers of GLX2 http://www.daniels-mara.com/glx2 On Mar

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-24 Thread Jerry Daniels
William, I have just uploaded a new beta to our update server. You and all other licensees can now update to b41. It has several small bug fixes in it, including the restoration of the default folder under any and all circumstances where GLX2 might need to set it. Best, Jerry Daniels

GLX2 new feature when working with SQLite databases and database query builder

2008-03-22 Thread william humphrey
I just changed the subject I just updated to GLX 2.1b40 and it did something (automatically) that I realize now is very cool but which caused me some consternation. It made a GLX2 Work Spaces folder in the My Revolution Studio folder and put an empty copy of my SQLite database there. This caused

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-22 Thread Sarah Reichelt
On Sun, Mar 23, 2008 at 1:26 AM, william humphrey [EMAIL PROTECTED] wrote: I just changed the subject I just updated to GLX 2.1b40 and it did something (automatically) that I realize now is very cool but which caused me some consternation. It made a GLX2 Work Spaces folder in the My

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-22 Thread william humphrey
Can you tell me why specialFolderPath(Documents) has Documents in there? Is it a way to set that type of folder path as opposed to one that is an application for RunRev to use instead of a Document? ___ use-revolution mailing list

Re: GLX2 new feature when working with SQLite databases and database query builder

2008-03-22 Thread william humphrey
Sarah Ignore that question please. I looked it up. Bill On Sat, Mar 22, 2008 at 6:31 PM, william humphrey [EMAIL PROTECTED] wrote: Can you tell me why specialFolderPath(Documents) has Documents in there? Is it a way to set that type of folder path as opposed to one that is an application for

Re: Need for Speed (databases)

2007-07-17 Thread viktoras didziulis
sharing the info on how to use sqlite in memory databases from within Revolution. Just tested in on my Rev, it works, so it may be useful for you too. Say we have my.db database file. We wish to load it as an in memory database to increase query performance. Here is the algorithm in SQL

Re: All this talk about DataBases - but how to select?

2007-06-01 Thread Scott Kane
From: -= JB =- [EMAIL PROTECTED] It's in your Rev directly if you are using it inside the IDE. :-) My bad. It should read directory as in a folder. Open your Rev folder (where Rev lives on your computer) and you'll find it there. You can open the file using any text editor. The file

Re: All this talk about DataBases - but how to select?

2007-06-01 Thread -= JB =-
On Jun 1, 2007, at 2:07 AM, Scott Kane wrote: It's in your Rev directly if you are using it inside the IDE. :-) Scott Hi Scott, Thanks for the reply. If it is directly in Rev how do I look at it, move it or remove it if I want to. -=JB=-

Re: All this talk about DataBases - but how to select?

2007-06-01 Thread -= JB =-
On May 31, 2007, at 10:07 PM, -= JB =- wrote: That is very nice. Where exactly is the text file being saved right now? thanks, -=JB=- Don't get me wrong. I know the handler to save the data is in the script of the okay button and the handler script is located in the

Re: All this talk about DataBases - but how to select?

2007-06-01 Thread Scott Kane
From: -= JB =- [EMAIL PROTECTED] I am not able to find the actual text file after it's saved. Is it saved as a file on my hard drive and I just can't find it or is it somehow saved as a file inside the stack. It's in your Rev directly if you are using it inside the IDE. :-) Scott

RE: All this talk about DataBases - Valentina

2007-06-01 Thread Lynn Fredricks
I have read some about Valentina. They say it is fast and can be used with the Studio version of Rev. Oracle needs the higher version of Rev. I tried to read the license to learn about any royalties I would need to pay with Valentina but I really didn't find the

Re: All this talk about DataBases - but how to select?

2007-06-01 Thread -= JB =-
On Jun 1, 2007, at 3:44 AM, Scott Kane wrote: From: -= JB =- [EMAIL PROTECTED] It's in your Rev directly if you are using it inside the IDE. :-) My bad. It should read directory as in a folder. Open your Rev folder (where Rev lives on your computer) and you'll find it there. You can

Re: All this talk about DataBases - Valentina

2007-06-01 Thread -= JB =-
On Jun 1, 2007, at 7:56 AM, Lynn Fredricks wrote: Unless you want to do something that violates the EULA, Valentina is royalty free. With the ADKs its pretty simple - you can develop and deploy as many as many apps as you like and ship as many units as you like. With VDN, you can deploy

Re: All this talk about DataBases - but how to select?

2007-06-01 Thread Mark Talluto
On Jun 1, 2007, at 12:07 AM, -= JB =- wrote: That is very nice. Where exactly is the text file being saved right now? Thanks! It is saving the file in the same directory as the engine if you use it in the Rev IDE. I use this program in a standalone form. So it saves it in the

AW: All this talk about DataBases - but how to select?

2007-05-31 Thread Tiemo Hollmann TB
about DataBases - but how to select? Tiemo Hollmann TB wrote: Now I have to get into this very interesting thread as a rev novice too. Storing data is one thing and the possibilities of rev are really perfect. But how do you get a good performance accesing the however stored datas

All this talk about DataBases - but how to select?

2007-05-31 Thread Peter Alcibiades
Well first of all, thanks yet again to Jacque for Find and Mark and Scroll through - wonderful, thanks! Another of these things which are totally obvious the minute you read them, and which you would never have found for yourself. Here is what I don't get though about Richard's approach.

Re: All this talk about DataBases - but how to select?

2007-05-31 Thread Bill
the speed of accessing filemaker databases through RunRev yet. Anyone done this? On 5/31/07 3:34 AM, Peter Alcibiades [EMAIL PROTECTED] wrote: Its the kind of thing which would take me all of an hour in Filemaker complete with the csv import

Re: All this talk about DataBases - but how to select?

2007-05-31 Thread Ruslan Zasukhin
using filemaker with the RunRev frontend because filemaker has lots of stuff already done for me (much more than the SQLitemanager) so using it in conjunction with RunRev might be a really powerful solution. EXCEPT I haven't tested the speed of accessing filemaker databases through RunRev

Re: All this talk about DataBases - but how to select?

2007-05-31 Thread J. Landman Gay
for your own use, then you won't have to do that, of course, because you'll probably just rescript your original. I have a lot of personal databases written this way and they work fine, but I'm the only one using them. Find and Mark will evidently let you produce a scrollable set of cards very

Re: All this talk about DataBases

2007-05-31 Thread -= JB =-
On May 31, 2007, at 1:55 PM, J. Landman Gay wrote: Or you could store it in a text file and just read that in. In any case, it's all the same approach; store the data as a single text variable. With this method, you use offset() or lineoffset() to find the record(s) you want, and use a

Re: All this talk about DataBases - Valentina

2007-05-31 Thread -= JB =-
one that is actual is there one that is practical. At what point doe the find command get too slow while searching a field or other things like sorting etc. thanks, -=JB=- Revolution explains Databases and when it is more efficient to use one in Chapters 2 and 8 of the Revolution

Re: All this talk about DataBases - but how to select?

2007-05-31 Thread Mark Talluto
On May 31, 2007, at 3:55 PM, J. Landman Gay wrote: Or you could store it in a text file and just read that in. In any case, it's all the same approach; store the data as a single text variable. With this method, you use offset() or lineoffset() to find the record(s) you want, and use a

Re: All this talk about DataBases - but how to select?

2007-05-31 Thread -= JB =-
On May 31, 2007, at 9:06 PM, Mark Talluto wrote: Here is an example of this method. I use this to customer data and registration information. Once can easily modify it to match their needs. www.canelasoftware.com/pub/rev/Key_Maker.rev.zip I removed some code that makes our key system

Re: All this talk about DataBases

2007-05-30 Thread Scott Kane
From: Richard Gaskin [EMAIL PROTECTED] Richard, Everything in computing involves tradeoffs. The question of HC's storage vs. Rev's is about paging: Indeed. Makes sense. With unusual care it was possible to have an unusually low number of corrupted stacks in HC, but I never met a

All this talk about DataBases

2007-05-30 Thread Peter Alcibiades
And think about it: since every Rev object has multiple property sets, and a stack can have any number of cards, and cards can have groups, etc. -- all this means you can have richly hierarchically-ordered data sets using just custom properties. Hierarchies reflect much of the world's

All this talk about DataBases - but how to select?

2007-05-30 Thread Tiemo Hollmann TB
Now I have to get into this very interesting thread as a rev novice too. Storing data is one thing and the possibilities of rev are really perfect. But how do you get a good performance accesing the however stored datas in a stack (cards / properties / properties loaded into arrays)? Saying I

Re: All this talk about DataBases

2007-05-30 Thread Scott Kane
From: Peter Alcibiades [EMAIL PROTECTED] Guys, if this is such a great feature of Revolution - and I believe it, the description is suggestive, promising, interesting - possibly someone with the good of the platform at heart should consider writing a tutorial and example on it? Dan

Re: All this talk about DataBases

2007-05-30 Thread Chipp Walters
On 5/30/07, Scott Kane [EMAIL PROTECTED] wrote: I've read about this from time to time. As I know you'll be aware we have this problem on Windows no matter what we do to the file or the file type -but it's become a heck of a lot better since Windows 2000 and up. Hi Scott, Are you saying you

Re: All this talk about DataBases

2007-05-30 Thread Scott Kane
From: Chipp Walters [EMAIL PROTECTED] G'day Chipp, Are you saying you have Rev stack corruption problems on Windows? One person had problems on Win 98 with one of my stacks. Repeatedly. I took the same application to another machine (running Win 2K) and there was not a single error.

RE: All this talk about DataBases

2007-05-30 Thread Lynn Fredricks
. Plus, there are a number of huge advantages of using real databases. Concurrent users, real transaction management, stored procs, etc.. I strongly agree with Chipp - of course I have some interest in databases with Valentina. An application development environment really has to be able to do

Re: All this talk about DataBases

2007-05-30 Thread Scott Kane
From: Lynn Fredricks [EMAIL PROTECTED] I strongly agree with Chipp - of course I have some interest in databases with Valentina. An application development environment really has to be able to do everything, yet it cannot be good at everything. By storing data in a database, you can leverage

Re: All this talk about DataBases

2007-05-30 Thread Dave Cragg
On 30 May 2007, at 04:57, Joe Lewis Wilkins wrote: Jesse, In case you don't know. HyperCard was written by a genius in assembly language. Here I'm going to make an assumption (with all of the known dangers of doing so), Rev was written by a good programmer; probably in a high or higher

Re: All this talk about DataBases

2007-05-30 Thread Joe Lewis Wilkins
Hey Dave, My first comment when I started this thread was another great controversy (smile). No question but what HC had its limitations. Without CompileIt I would have been real discouraged back then; but as the machines got faster, particularly with my externals written in native

Re: All this talk about DataBases

2007-05-30 Thread Rob Cozens
Scott, Joe, et al: I believe Rob Cozens does something of the sought [partially load a db stack] with Serendipity, but the question is whether it's really worth while given it's all there already with a real database. I've followed this thread this far wondering should I bother to mention

Re: All this talk about DataBases

2007-05-30 Thread Rob Cozens
Richard, et al: Why bother with the overhead of storing the data in fields on cards, when you can easily parse item and line chunks of a single block of data so very efficiently? This is basically how SDB handles non-binary data. The field delimiter character for each record type is

Re: All this talk about DataBases

2007-05-30 Thread J. Landman Gay
Scott Kane wrote: - Original Message - Mac OS X. It was very fast loading the text file. But each record was fairly small, so 40,000 of them wasn't as large as one might think. It was measured in megs rather than gigs, but I don't remember exactly how big it was. The original data

Re: All this talk about DataBases

2007-05-30 Thread Mark Smith
On the other hand (and I'm not actually advocating it, since I've never tried it), it would also be possible to build indexes of the data that are kept in memory, while keeping the actual data in a collection of many stack files which are then loaded and unloaded as required. As I say,

Re: All this talk about DataBases

2007-05-30 Thread Andre Garzia
I'd go for SQLite or Valentina. trying to make sense out of 1 million records, you need a good query language, one that is able to do more than one operation with a single query. Just imagine looping your indexes over and over again trying to find the cross-references you're looking for.

Re: All this talk about DataBases - but how to select?

2007-05-30 Thread J. Landman Gay
with properties or arrays? With that much data, a SQL database is better. For smaller databases, you can create one card per record and use the mark command to flag the cards that match. For example: mark cards by finding my string or: mark cards by finding whole my string in field 2 or: mark

Re: All this talk about DataBases

2007-05-30 Thread Luis
looks around Am I the only one to have just heard of SDB? More infos? Links? Cheers, Luis. On 30 May 2007, at 17:32, Rob Cozens wrote: Scott, Joe, et al: I believe Rob Cozens does something of the sought [partially load a db stack] with Serendipity, but the question is whether it's

Re: All this talk about DataBases

2007-05-30 Thread Scott Kane
From: Rob Cozens [EMAIL PROTECTED] Hi Rob, I've followed this thread this far wondering should I bother to mention SDB, considering the underwhelming response it has received from the RunRun community? No disrespect meant by my reference to Serendipity. Scott Andre might offer some

Re: All this talk about DataBases

2007-05-30 Thread Scott Kane
From: J. Landman Gay [EMAIL PROTECTED] I think that pretty much requires an external database. If you dump that much data into a stack I don't think you'll like the results. Indeed and I would never dream, normally, of anything less. But I was curious to see how far I could push the

Re: All this talk about DataBases

2007-05-30 Thread Scott Kane
From: Andre Garzia [EMAIL PROTECTED] I'd go for SQLite or Valentina. trying to make sense out of 1 million records, you need a good query language, one that is able to do more than one operation with a single query. Just imagine looping your indexes over and over again trying to find the

Re: All this talk about DataBases - but how to select?

2007-05-30 Thread Scott Kane
From: J. Landman Gay [EMAIL PROTECTED] G'day Jacqueline, With that much data, a SQL database is better. For smaller databases, you can create one card per record and use the mark command to flag the cards that match. For example: snip helpfule pseudo code Then you loop through the marked

Re: All this talk about DataBases

2007-05-30 Thread -= JB =-
I have never used Valentina or the other database mentioned but here is a question if I decide to use one I make in Revolution. One user said he was working with one million or more files so lets use that as an example. If I were to make a text file with one million card ids in item one and the

Re: All this talk about DataBases

2007-05-30 Thread Scott Kane
From: -= JB =- [EMAIL PROTECTED] One user said he was working with one million or more files so lets use that as an example. If I were to make a text file with one million card ids in item one and the user name in item two and then put it into a variable and perform a search for the id and

Re: All this talk about DataBases

2007-05-30 Thread Mark Wieder
Rob- Wednesday, May 30, 2007, 9:32:51 AM, you wrote: I've followed this thread this far wondering should I bother to mention SDB, considering the underwhelming response it has received from the RunRun community? Interesting. From my end of things, I think the underwhelming response is

sqlite in-memory databases

2007-05-29 Thread Viktoras Didziulis
Hi, does anyone know if after I create an in-RAM database using sqlite3 memory and then do for any stored database file: ATTACH db_file AS db_ram does it also load the attached database into RAM or continues to query the attached database as it is (e.g. disk file) ? Any experiences with

All this talk about DataBases

2007-05-29 Thread Joe Lewis Wilkins
Hi all, Guess I'm going to start up another great controversy. Again I'm hearkening back to my HC days. When it was first released, one of its main claims to fame was the question as to whether or not it WAS a database. Certainly, it had all of the attributes and features of one. Even

Re: All this talk about DataBases

2007-05-29 Thread Andre Garzia
Joe, check http://www.himalayanacademy.com/resources/lexicon it is a lexicon for those interested in Hinduism. It not only performs searches but it has cross-references between words. For example search for karma or vedas, if you want to see a quick query just search for a this will give

Re: All this talk about DataBases

2007-05-29 Thread Scott Kane
From: Joe Lewis Wilkins [EMAIL PROTECTED] Guess I'm going to start up another great controversy. I shouldn't think. This is a very interesting discussion AFA I am concerned at any rate. Again I'm hearkening back to my HC days. When it was first released, one of its main claims to fame

Re: All this talk about DataBases

2007-05-29 Thread Scott Kane
From: Andre Garzia [EMAIL PROTECTED] check http://www.himalayanacademy.com/resources/lexicon it is a Very impressive! Scott Kane CD Too - Voice Overs Artist Original Game and Royalty Free Multi-Media Music Any sufficiently advanced technology is indistinguishable from magic. Arthur C

Re: All this talk about DataBases

2007-05-29 Thread Joe Lewis Wilkins
Andre, Thanks, you've confirmed my suspicions. So most of us don't really need to be concerned with other DBs. Joe Wilkins On May 29, 2007, at 7:50 PM, Andre Garzia wrote: Joe, check http://www.himalayanacademy.com/resources/lexicon it is a lexicon for those interested in Hinduism. It

Re: All this talk about DataBases

2007-05-29 Thread Sarah Reichelt
Guess I'm going to start up another great controversy. Again I'm hearkening back to my HC days. When it was first released, one of its main claims to fame was the question as to whether or not it WAS a database. Certainly, it had all of the attributes and features of one. Even with SE30s as a

Re: All this talk about DataBases

2007-05-29 Thread Andre Garzia
the operations, build the response and shut everything down. This all happens very quickly. Coding databases in Rev is not like doing SQL databases at all, you need to code your software in smart ways, like build indexes and really think about your search and cross-reference routines

  1   2   3   >