Re: [OT] mySQL Client
On Tue, Dec 13, 2016 at 8:18 AM, Bob Sneidar wrote: > That is odd. I recently did that very thing. I started a transaction and then > ran multiple updates in a repeat loop, then committed the transaction. Seemed > like all the data ended up in the tables. > That sounds like you did NOT do the very same thing. If you used a repeat loop it sounds like you were firing off updates one after the other - lets say 100 updates were handled as 100 executions. The good Dr is talking about COMPOUNDING all those 100 update statements into a single LC revExecuteSQL statement and firing just one off. This works for SQLite and postgreSQL but not mySQL. Back to your original question; I've used both Navicat and Valentina Studio (free version) with success. Years ago Valentina was less stable and so I'd use Navicat if things went a bit flakey, but these days I find the Valentina UI more intuitive and screen space efficient so rarely every start up Navicat. ___ 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: [OT] mySQL Client
That is odd. I recently did that very thing. I started a transaction and then ran multiple updates in a repeat loop, then committed the transaction. Seemed like all the data ended up in the tables. Bob S > On Dec 10, 2016, at 12:16 , Dr. Hawkins wrote: > > One thing to note: at the moment (and future???), you cannot send compound > transactions from LiveCode to mySQL. I understand this to be a livecode > issue. > > So > > BEGIN TRANSACTION; > > INSERT THIS; > > SELECT THAT; > > DO SOMETHING ELSE; > > END TRANSACTION; > > > can be handled with a single query in livecode with SQLite and postgreSQL, > but requires five separate transactions for mySQL. > > If latency is an issue, this is a killer . . . > > > -- > Dr. Richard E. Hawkins, Esq. > (702) 508-8462 > ___ > 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: [OT] mySQL Client
One thing to note: at the moment (and future???), you cannot send compound transactions from LiveCode to mySQL. I understand this to be a livecode issue. So BEGIN TRANSACTION; INSERT THIS; SELECT THAT; DO SOMETHING ELSE; END TRANSACTION; can be handled with a single query in livecode with SQLite and postgreSQL, but requires five separate transactions for mySQL. If latency is an issue, this is a killer . . . -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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: [OT] mySQL Client
SequelPro for sure! riccardo > Il giorno 09 dic 2016, alle ore 18:40, Bob Sneidar > ha scritto: > > Hi all. > > I am using mySQL as a database server, and MySQLWorkbench as the management > app. When I do dumps, I am warned that the version of msSQL is newer than my > version of mySQL server, and because of that there may be problems importing > later. This makes me very nervous. > > So does anyone have any recommendations for an administration tool that is > not going to give me problems at a later time? I don't mind paying for it if > it's not too expensive, but it has to run on OS X. I can google it but I'd > like a trusted opinion. > > Bob S > ___ > 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: [OT] mySQL Client
I love using Sequel Pro, use it on a daily base without any problems... Met vriendelijke groeten, Warm Regards, Ton Kuypers +32 (0) 477 739 530 Steenweg op Leopoldsburg 100 • B-2490 • Balen • Belgium www.publishingtools4u.com > On 9 dec. 2016, at 18:40, Bob Sneidar wrote: > > Hi all. > > I am using mySQL as a database server, and MySQLWorkbench as the management > app. When I do dumps, I am warned that the version of msSQL is newer than my > version of mySQL server, and because of that there may be problems importing > later. This makes me very nervous. > > So does anyone have any recommendations for an administration tool that is > not going to give me problems at a later time? I don't mind paying for it if > it's not too expensive, but it has to run on OS X. I can google it but I'd > like a trusted opinion. > > Bob S > ___ > 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: [OT] mySQL Client
> So does anyone have any recommendations for an administration > tool that is not going to give me problems at a later time? I > don't mind paying for it if it's not too expensive, but it > has to run on OS X. I can google it but I'd like a trusted opinion. Obviously am biased towards Valentina Studio Pro, but give me credit for this - our free version might be all you need. It runs on Windows, Linux and Mac OS X. We also have a competitive upgrade from Navicat if you go that way and regret it. Best regards, Lynn Fredricks Paradigma Software http://www.paradigmasoft.com Valentina SQL Server: The Ultra-fast, Royalty Free Database Server ___ 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: [OT] mySQL Client
Thanks Bill. It dawns on me (and the dawn has been coming later and later these days) that I actually purchased Navicat some years back. I should check to see if my license is still good. Bob S > On Dec 9, 2016, at 10:44 , proth...@earthlearningsolutions.org wrote: > > Bob, > I've used Navicat for years. I like it a lot. > Bill > > William Prothero > http://es.earthednet.org > >> On Dec 9, 2016, at 9:40 AM, Bob Sneidar wrote: >> >> Hi all. >> >> I am using mySQL as a database server, and MySQLWorkbench as the management >> app. When I do dumps, I am warned that the version of msSQL is newer than my >> version of mySQL server, and because of that there may be problems importing >> later. This makes me very nervous. >> >> So does anyone have any recommendations for an administration tool that is >> not going to give me problems at a later time? I don't mind paying for it if >> it's not too expensive, but it has to run on OS X. I can google it but I'd >> like a trusted opinion. >> >> Bob S >> ___ >> 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: [OT] mySQL Client
Bob, I've used Navicat for years. I like it a lot. Bill William Prothero http://es.earthednet.org > On Dec 9, 2016, at 9:40 AM, Bob Sneidar wrote: > > Hi all. > > I am using mySQL as a database server, and MySQLWorkbench as the management > app. When I do dumps, I am warned that the version of msSQL is newer than my > version of mySQL server, and because of that there may be problems importing > later. This makes me very nervous. > > So does anyone have any recommendations for an administration tool that is > not going to give me problems at a later time? I don't mind paying for it if > it's not too expensive, but it has to run on OS X. I can google it but I'd > like a trusted opinion. > > Bob S > ___ > 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
[OT] mySQL Client
Hi all. I am using mySQL as a database server, and MySQLWorkbench as the management app. When I do dumps, I am warned that the version of msSQL is newer than my version of mySQL server, and because of that there may be problems importing later. This makes me very nervous. So does anyone have any recommendations for an administration tool that is not going to give me problems at a later time? I don't mind paying for it if it's not too expensive, but it has to run on OS X. I can google it but I'd like a trusted opinion. Bob S ___ 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
