[intel352]

'peterlaursen' wrote:

You cannot really 'fork' SQLyog to Linux.. It is not because license would prevent 'forking' to Linux (anybody can start tonight with the COMMUNITY version and could for 4 years but nobody did yet). But it technically notreally possible unless completely rewriting major parts of the program and replacing the Win 32 API with other libraries. And there is none available that are a simple 'plugin replacement' (except for Winelib that would just embed a Wine instance into SQLyog itself). For instance most of all the rich functionalities of the SQLyog GRID class would require tremendous amounts of work to port to Linux.. And we believe that few Linux users would pay for – or even contribute much to – that work.

SQLyog is now a very complex program (with 1 million+ code lines for more than 4 years as far as I have been told). People developing it and testing it earn salaries in order to sustain their families. We are not a charity. We do not believe that the benefits of a Linux version justifies the effort and expenses. People would love it maybe – but would not pay 5% of what it would take to develop it.

You do not grow apples on an orange tree (or vice versa). Burt I like both apples and oranges! But I earn my living from oranges as long as people think that apples must be free.

While I agree that porting to Linux itself would likely not be worthwhile enough (most Linux users tend to avoid paying for software when possible), a BSD port would likely be worthwhile, as it could be the basis for a Mac version as well. And we all know that Mac users will gladly overpay for both hardware and software 🙂

I would personally love to see SQLYog on Mac and/or Linux. If my “free” time wasn't already consumed with work, then I would work towards porting the code myself.

Peter, are there not libraries that the SQLYog team could start implementing into the software to make it more cross-platform compatible? i.e. – slowly swapping out bits where possible, to make the software more versatile?

Even if the libs implemented didn't provide outright support for Mac/Linux immediately, if they were libs/apis that were not so specifically tied to Windows, that would better enable the chances of ports to exist.

Plus, once you guys can get a proper open-source community thriving, that can start driving development further. Especially if SQLYog development ever moves to Mercurial or Git (and even better if hosted on Github or Bitbucket, rather than Google Code), so that the code could be more readily forked so that others could more readily contribute.

It may be worth considering for a long-term plan, especially considering how Apple's market share (especially in mobile & tablets) is growing considerably.

[intel352]

'peterlaursen' wrote:

Forget about SQLyog MAX! Use SQLyog with Wine instead:

http://webyog.com/faq/content/31/71/en/can…r-on-linux.html

independent reviews:

http://appdb.winehq.org/objectManager.php?…on&iId=1328

It would be nice to get SQLYog running in native Linux. Running under Wine often shows display/rendering issues, poor performance, etc.

I'm surprised no Linux enthusiasts have forked the Community Edition to get it into a Linux environment. Perhaps the license is stopping people? (Just an assumption, haven't seen the license)

[intel352]

'navyashree.r' wrote on '31:

We have fixed this in 7.12 just released. Thank You.

Regards,

Navya

Curious, why is a developer team member showing as “banned”?

[intel352]

Good to know, thanks 🙂

[intel352]

For instance, when looking for the icon to “delete selected row”, it's not as obvious as it used to be which icon to use.

The icon is primarily a grid, that has an ULTRA SMALL red circle with minus sign in lower right. what the heck is the thought there?

I'm sure when the icons were being designed, and being viewed zoomed-in within Photoshop or whatever was used, that they made sense and looked stylish, but in terms of practical usability, visibility, it just doesn't work.

Additionally, changing the “execute query” icon from green, to blue, doesn't help too much, aesthetically.

Is it possible for me to replace the actual icons somewhere manually?

[intel352]

Thanks for the detailed answer, I appreciate it.

[intel352]

just a quick point, please optimize the SELECT COUNT so that it counts the PK only, to avoid needless extra data being called (SELECT COUNT(PRIMARY_KEY_NAME), instead of SELECT COUNT(*) )

[intel352]

I'll try the server-side logging, thanks.

Regarding the timestamps, I've had no issue using this method with source->target syncs, other than these exact same rows constantly being sent. The timestamps are all managed locally (when a row is updated, the timestamp is modified), so the exact same timestamps are sent to the MySQL server, and are not modified automatically by MySQL.

on the MySQL server, I execute a MAX(fieldname) query to grab the latest timestamp, that is lesser-than-or-equal-to NOW(). I then use that value to query the SQL server, pulling all rows that are greater-than-or-equal-to DATE-VALUE. So all values are sent to MySQL that have a timestamp greater than the MySQL MAX date value, and primary ids are used to prevent data duplication.

I'm not actively converting the TIMESTAMP values to an integer, to my knowledge, so I don't think that's a factor here.

Again, this method works for some tables perfectly, resulting in 0 rows being sent when there are no new changes… It's very strange.

I'll post once I find out what the Logs have to reveal.

[intel352]

okay, thanks for the info. does it seem to you that “getdate()” is the only function that needs to be converted? (according to the error logs?)

[Author]

Posts