ANN: Upscene releases Database Workbench 5.6.0

2019-02-26 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

“ Database Workbench 5.6.0 "

This new release brings you the Command Line Data Pump & Favorites feature (Pro 
Edition) and a few important bugfixes. 

Version 5.5 brought you support for the latest versions of supported database 
systems, that includes PostgreSQL 11, InterBase 2017 and MySQL 8.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!

Here's the full list of changes
http://www.upscene.com/go/?go=tracker=5.6.0=12
and for version 5.5.0
http://www.upscene.com/go/?go=tracker=5.5.0=12

For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

ANN: Database Workbench 5.5.0 released and free Lite Edition for MySQL

2019-01-15 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.5.0

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.5.0 "

This new release brings you support for the latest versions of supported 
database systems, that includes PostgreSQL 11, InterBase 2017 and MySQL 8.

There's also a new release of the free Lite Edition for MySQL: version 5.4.6 
has been made available today.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!

Here's the full list of changes
http://www.upscene.com/go/?go=tracker=5.5.0=12
and for version 5.4.x
http://www.upscene.com/go/?go=tracker=5.4.x=12

For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?

2018-10-30 Thread Martijn Tonies (Upscene Productions)
Hi there,

In MySQL 8, how can you figure out if an entry in the mysql.user table is a 
role or a user?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

ANN: Upscene releases Database Workbench 5.4.6

2018-10-23 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.4.6

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

“ Database Workbench 5.4.6 "

This is a bugfix release, previous releases included support for MariaDB 10.1 
and 10.2, MySQL 5.7 and Azure, a custom report writer, a renewed stored routine 
debugger with full support for Firebird 3 Stored Functions and Packages and 
several other features.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!

Here's the full list of changes
http://www.upscene.com/go/?go=tracker=5.4.x=12

For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

ANN: Upscene releases Database Workbench 5.4.4

2018-07-09 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version 
of the popular multi-DBMS development tool:

" Database Workbench 5.4.4 “

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure 
and the latest version of PostgreSQL. Previous releases included a custom 
report writer, a renewed stored routine debugger with full support for Firebird 
3 Stored Functions and Packages and several other features.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!

Here's the full list of changes
http://www.upscene.com/go/?go=tracker=5.4.x=12

For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

ANN: Stored routine debugger Hopper, version 2.0.1 released

2018-06-27 Thread Martijn Tonies (Upscene Productions)
Dear ladies and gentlemen,

Upscene Productions is proud to announce version 2.0.1 of "Hopper", a stored
routine debugger for InterBase, Firebird and MySQL.

Major version 2 has a fully renewed user interface, support for Firebird 3
packages, stored functions, MySQL diagnostic-statements, binary data in 
variables and much more.


For more information, see http://www.upscene.com/go/?go=news=20180627


With regards,

Martijn Tonies

Upscene Productions
http://www.upscene.com

ANN: Upscene releases Database Workbench 5.4.2

2018-03-06 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.4.2

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.4.2 “

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure 
and the latest version of PostgreSQL. Previous releases included a custom 
report writer, a renewed stored routine debugger with full support for Firebird 
3 Stored Functions and Packages and several other features.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!

Here's the full list of changes
http://www.upscene.com/go/?go=tracker=5.4.x=12

For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

ANN: Upscene releases Database Workbench 5.4.0

2018-02-05 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.4.0 "

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure 
and the latest version of PostgreSQL. Previous releases included a custom 
report writer, a renewed stored routine debugger with full support for Firebird 
3 Stored Functions and Packages and several other features.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!

Here's the full list of changes
http://www.upscene.com/go/?go=tracker=5.4.0=12

For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

In MySQL 8.0, how does one recognize roles?

2018-01-09 Thread Martijn Tonies (Upscene Productions)
Hi,

In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users

But how does one distinguish between roles and users?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

ANN: Upscene releases Database Workbench 5.3.4

2017-10-27 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version 
of the popular multi-DBMS development tool:

" Database Workbench 5.3.4 "

This release includes bugfixes on version 5.3 which included a custom report 
writer, increased support for PostgreSQL, a renewed stored routine debugger 
with full support for Firebird 3 Stored Functions and Packages and adds several 
other features.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!


"Version 5 included many new features", says Martijn Tonies, founder of Upscene 
Productions. 
"It added code editor features, has diagramming improvements, multiple 
editions, is fully HiDPI aware and offers secure connections to PostgreSQL, 
MySQL and MariaDB. The most recent version adds a custom report writer and 
increased support for PostgreSQL, as requested by many of our customers."

Here's the full list of changes
http://www.upscene.com/go/?go=tracker=5.3.4=12

For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

ANN: Stored routine debugger Hopper, version 2.0 released

2017-10-20 Thread Martijn Tonies (Upscene Productions)
Dear ladies and gentlemen,

Upscene Productions is proud to announce version 2 of "Hopper", a stored
routine debugger for InterBase, Firebird and MySQL.

This version includes support for Firebird 3 packages and stored functions,
MySQL diagnostic-statements, binary data in variables and much more.


For more information, check the Hopper page on this website. 
http://www.upscene.com/stored_procedure_debugger/



About Hopper
Hopper is a stored routine debugging tool for MySQL, Firebird and InterBase. If 
you use
stored procedures on these database systems, Hopper will be a great tool for 
debugging
these routines.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 15 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

Upscene releases Database Workbench 5.3.2

2017-06-30 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

“ Database Workbench 5.3.2 “

This release includes bugfixes on version 5.3 which included a custom report 
writer, increased support for PostgreSQL, a renewed stored routine debugger 
with full support for Firebird 3 Stored Functions and Packages and adds several 
other features.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!



"Version 5 included many new features", says Martijn Tonies, founder of Upscene 
Productions. 
"It added code editor features, has diagramming improvements, multiple 
editions, is fully HiDPI aware and offers secure connections to PostgreSQL, 
MySQL and MariaDB. The most recent version adds a custom report writer and 
increased support for PostgreSQL, as requested by many of our customers."

Here's the full list of changes
http://www.upscene.com/go/?go=tracker=5.3.2=12

For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

Upscene releases Database Workbench 5.3

2017-04-19 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.3 "

This release includes a custom report writer, increased support for PostgreSQL, 
a renewed stored routine debugger with full support for Firebird 3 Stored 
Functions and Packges and adds several other features.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!



"Version 5 included many new features", says Martijn Tonies, founder of Upscene 
Productions. 
"It added code editor features, has diagramming improvements, multiple 
editions, is fully HiDPI aware and offers secure connections to PostgreSQL, 
MySQL and MariaDB. The most recent version adds a custom report writer and 
increased support for PostgreSQL, as requested by many of our customers."


For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

Starting MySQL takes a long long time

2016-10-10 Thread Martijn Tonies (Upscene Productions)
Hello all,

Had a normal MySQL shutdown, reboot and then this happens:

161010 10:58:30 [Note] Plugin 'FEDERATED' is disabled.
161010 10:58:31 InnoDB: The InnoDB memory heap is disabled
161010 10:58:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
161010 10:58:31 InnoDB: Compressed tables use zlib 1.2.3
161010 10:58:32 InnoDB: Initializing buffer pool, size = 107.0M
161010 10:58:32 InnoDB: Completed initialization of buffer pool
161010 10:58:32 InnoDB: highest supported file format is Barracuda.
161010 10:58:39  InnoDB: Waiting for the background threads to start
161010 10:58:40 InnoDB: 1.1.8 started; log sequence number 5809271388
161010 11:42:54 [Note] Event Scheduler: Loaded 0 events
161010 11:42:54 [Note] C:\Program Files (x86)\MySQL\MySQL Server 
5.5\bin\mysqld: ready for connections.
Version: '5.5.15'  socket: ''  port: 3306  MySQL Community Server (GPL)

What is causing the delay between starting InnoDB and finishing this startup?


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

ANN: Database Workbench 5.2 now includes PostgreSQL support

2016-09-08 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.2 "

This release includes support for PostgreSQL and adds several other features.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!



"Version 5 included many new features", says Martijn Tonies, founder of Upscene 
Productions. 
"It added code editor features, has diagramming improvements, multiple 
editions, is fully HiDPI aware and offers tunnelling for MySQL and MariaDB 
connections.
The most recent version adds support for PostgreSQL, as requested by many of 
our customers."


For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.



ANN: Upscene releases Database Workbench 5.1.12

2016-03-23 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.1.12

Upscene Productions is proud to announce a new release 
of the popular multi-DBMS development tool:

“ Database Workbench 5.1.12 “

This release adds a few small features and useful enhancements.

The full version 5.1.x change log is available here:
http://www.upscene.com/go/?go=tracker=5.1.x=12


Version 5 added numerous new features and improvements to existing tools and 
the new, more consistent user interface is better than ever and works fine 
under Wine on Linux.

Version 5.1 includes SQL Azure and Firebird 3 support, additional data export 
functionality, improved Oracle XML and Object-type support, Diagramming 
enhancements 
and new printing features as well as improvements in other areas.

http://www.upscene.com/news/item/20160322


Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!



For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, 
SQL Azure,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

Upscene releases Database Workbench 5.1.10

2015-12-16 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release 
of the popular multi-DBMS development tool:

Database Workbench 5.1.10 

This release adds a few small features and includes Windows Terminal Server 
support.

The full version 5.1.x change log is available here:
http://www.upscene.com/go/?go=tracker=5.1.x=12


Version 5 added numerous new features and improvements to existing tools and 
the new, more consistent user interface is better than ever and works fine 
under Wine on Linux.


Version 5.1 includes SQL Azure and Firebird 3 support, additional data export 
functionality, improved Oracle XML and Object-type support, Diagramming 
enhancements 
and new printing features as well as improvements in other areas.

http://www.upscene.com/news/item/20151215


Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!



For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, 
SQL Azure,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.


ANN: 20% discount on Database Workbench Basic or Pro!

2015-11-04 Thread Martijn Tonies (Upscene Productions)
Dear reader,

We're offering a 20% Mid Autumn Discount on our database design
and development product "Database Workbench", available in Basic
and Pro edition.

Use coupon code MAD15 while ordering, valid until November the 9th.

You can find more information about Database Workbench here:
http://www.upscene.com/database_workbench/



Thank you.



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Upscene releases Database Workbench 5.1.6

2015-10-09 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.1.6

Upscene Productions is proud to announce a new release 
of the popular multi-DBMS development tool:

“ Database Workbench 5.1.6 "

This version is the next big release after version 5 and includes new features,
enhancements and fixes.

The full version 5.1.x change log is available here:
http://www.upscene.com/go/?go=tracker=5.1.x=12


Version 5 added numerous new features and improvements to existing tools and 
the new, more consistent user interface is better than ever and works fine 
under Wine on Linux.


Version 5.1 includes SQL Azure and Firebird 3 support, additional data export 
functionality, improved Oracle XML and Object-type support, Diagramming 
enhancements 
and new printing features as well as improvements in other areas.



Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!



For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, 
SQL Azure,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.

About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

Upscene releases Database Workbench 5.1.2

2015-07-15 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release 
of the popular multi-DBMS development tool:

“ Database Workbench 5.1.2 

This version is the next big release after version 5 and includes new features,
enhancements and fixes.

The change log is available here:
http://www.upscene.com/go/?go=trackerv=5.1.2id=12
http://www.upscene.com/go/?go=trackerv=5.1.0id=12


Version 5 added numerous new features and improvements to existing tools and 
the new, more consistent user interface is better than ever and works fine 
under Wine on Linux.


Version 5.1 includes SQL Azure and Firebird 3 support, additional data export 
functionality, improved Oracle XML and Object-type support, Diagramming 
enhancements 
and new printing features as well as improvements in other areas.



Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!



For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, 
SQL Azure,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import  export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

Upscene releases Database Workbench 5.1.0

2015-06-24 Thread Martijn Tonies (Upscene Productions)
For immediate release:
http://www.upscene.com/news/item/20150624

Upscene releases Database Workbench 5.1.0

Upscene Productions is proud to announce a new release 
of the popular multi-DBMS development tool:

“ Database Workbench 5.1 

This version is the next big release after version 5 and includes new features,
enhancements and fixes.

The change log is available here:
http://www.upscene.com/go/?go=trackerv=5.1.0id=12


Version 5 added numerous new features and improvements to existing tools and 
the new, more consistent user interface is better than ever and works fine 
under Wine on Linux.


Version 5.1 includes additional data export functionality, Firebird 3 support,
improved Oracle XML and Object-type support, Diagramming enhancements and new 
printing features as well as improvements in other areas.



Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!



For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import  export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

Upscene releases Database Workbench 5.0.10

2015-02-20 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release 
of the popular multi-DBMS development tool:

 Database Workbench 5 

This release fixes several issues as reported by our customers.

The change log is available here:
http://www.upscene.com/go/?go=trackerv=5.0.10id=12


Version 5 added numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on 
Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!



For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import  export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

ANN: Upscene releases Database Workbench 5.0.8

2015-01-21 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.0.8

Upscene Productions is proud to announce a new release 
of the popular multi-DBMS development tool:

 Database Workbench 5 

This release fixes several issues as reported by our customers.

The change log is available here:
http://www.upscene.com/go/?go=trackerv=5.0.8id=12


Version 5 added numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on 
Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!



For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import  export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

ANN: Advanced Data Generator 3.3.0 released

2014-12-17 Thread Martijn Tonies (Upscene Productions)
ANN: Advanced Data Generator 3.3.0 released

Dear ladies and gentlemen,

Upscene Productions is happy to announce the next release
of their Windows based flexible and easy to use test data 
generator tool:

Advanced Data Generator 3.3.0 

A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, many filling options, templates and 
much more.

Version 3 included many new features, eg:
* Unicode support in an all new fresh user interface
* Ability to use external databases as the source for data
* New and improved data libraries for real life like data
* New template types
* Much improved documentation with comprehensive How to-section

This product comes in four versions:
- Pro: ADO and ODBC connectivity
- InterBase Edition
- Firebird Edition
- MySQL Edition

More info and a 30-day trial version on www.upscene.com

Pricing information available on:
http://www.upscene.com/go/?go=purchase

More information available here:
http://www.upscene.com/go/?go=newsid=20141217



With regards,

Martijn Tonies
Upscene Productions - Database Tools for Developers
http://www.upscene.com

ANN: Database Workbench 5.0.6 released

2014-12-15 Thread Martijn Tonies (Upscene Productions)
ANN: Upscene releases Database Workbench 5.0.6

Upscene Productions is proud to announce a new release 
of the popular multi-DBMS development tool:

 Database Workbench 5 

Version 5.0.6 fixes an issue with the MySQL module and includes some changes
for Firebird 3.

The change log is available here:
http://www.upscene.com/go/?go=trackerv=5.0.6id=12


Version 5 added numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on 
Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!



For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import  export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.


With regards,

Martijn Tonies


Re: alter table for foreign key

2014-11-17 Thread Martijn Tonies (Upscene Productions)

Hi,

This is an example:

ALTER TABLE cart ADD CONSTRAINT fk_cart_customers FOREIGN KEY (custid)
 REFERENCES customers (custid)
 ON DELETE CASCADE
 ON UPDATE NO ACTION;

(take from the GUI tool Database Workbench, avoids having to know the syntax 
;) )



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

-Original Message- 
From: thufir

Sent: Monday, November 17, 2014 10:42 AM
To: mysql@lists.mysql.com
Subject: alter table for foreign key

Looking at the docs:

http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html

how do I alter the child table, links, so that it has a foreign key with
the parent table, feeds?

The feed_id field in links should, in fact, be constrained by the foreign
key of feeds with a RESTRICT reference option.



mysql
mysql show tables;
+---+
| Tables_in_rome_aggregator |
+---+
| feeds |
| links |
| pages |
+---+
3 rows in set (0.00 sec)

mysql
mysql describe feeds;
+--+--+--+-+-++
| Field| Type | Null | Key | Default | Extra  |
+--+--+--+-+-++
| id   | int(11)  | NO   | PRI | NULL| auto_increment |
| created  | datetime | NO   | | NULL||
| accessed | varchar(45)  | NO   | | NULL||
| url  | varchar(767) | NO   | UNI | NULL||
| status   | int(11)  | NO   | | 0   ||
+--+--+--+-+-++
5 rows in set (0.05 sec)

mysql
mysql describe links;
+-+--+--+-+-++
| Field   | Type | Null | Key | Default | Extra  |
+-+--+--+-+-++
| id  | int(11)  | NO   | PRI | NULL| auto_increment |
| created | datetime | NO   | | NULL||
| feed_id | int(11)  | NO   | | 0   ||
| link| varchar(767) | NO   | UNI | NULL||
| status  | int(11)  | NO   | | 0   ||
+-+--+--+-+-++
5 rows in set (0.00 sec)

mysql


While I know that I should alter the table, I don't know the syntax to
establish the foreign key constraint.


thanks,

Thufir


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: alter table for foreign key

2014-11-17 Thread Martijn Tonies (Upscene Productions)

On 14-11-17 01:42 AM, thufir wrote:

Looking at the docs:

http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html

how do I alter the child table, links, so that it has a foreign key with
the parent table, feeds?


The workbench GUI came up with:

ALTER TABLE `rome_aggregator`.`links`
ADD INDEX `fk_links_1_idx` (`feed_id` ASC);


In general, an index is used for performance, while a constraint is
used for logical concepts, like uniqueness. Most often, the DBMS uses
an index to implement these logical concepts, but it's better to understand
the difference.

A foreign key needs a unique constraint (either a primary of a secondary
unique constraint) to point to: when there's no uniqueness in the parent
table, it cannot point to a record in that table.


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



ANN: Upscene releases Database Workbench 5.0.4

2014-10-16 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.0.4

Upscene Productions is proud to announce a new release 
of the popular multi-DBMS development tool:

“ Database Workbench 5 

Version 5.0.4 introduces some small new features and a list of fixes
base on user feedback.

The change log is available here:
http://www.upscene.com/go/?go=trackerv=5.0.4id=12


Version 5 added numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on 
Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!

For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import  export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

ANN: Upscene releases Database Workbench 5.0.2

2014-09-18 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release 
of the popular multi-DBMS development tool:

 Database Workbench 5 

Version 5.0.2 fixed some issues that came to light after the initial
major version 5 release.

http://www.upscene.com/news/item/20140918

Version 5 added numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on 
Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!



A few bugs popped up after the initial version 5 release, all minor issues but 
also a lack of documentation 
showing in the trial version. I'm proud of the team that thoroughly tested the 
version 5 release, 
says Martijn Tonies, founder of Upscene Productions. The major version 5 
release adds adds code editor features, 
has diagramming improvements, comes in multiple editions, is fully HiDPI aware 
and offers tunnelling for MySQL 
and MariaDB connections. It all was a lot of work, but it was worth it!

We worked closely with out customer and implemented many of their requests and 
for
new users, we offer multiple editions to suit their development needs. From 
design to
productivity, there's new features and improvements in almost everything!



For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import  export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

Re: database developer tool Database Workbench 5 now available

2014-09-05 Thread Martijn Tonies (Upscene Productions)

Hello Jan, list,


From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!


Unless you don't do Winblows.

Please put Windows dependency clearly in your announcements and on your 
website. I couldn't find it anywhere, until I attempted a download, and got 
a useless .EXE file.


The announcement said:

 ... and works fine under Wine on Linux. 

Several of our customers are long-time Linux users and are very happy with
Database Workbench.

See also:
http://www.upscene.com/company/support/database_workbench_5_on_wine_ubuntu14

Hope this helps.


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: database developer tool Database Workbench 5 now available

2014-09-05 Thread Martijn Tonies (Upscene Productions)




MGMy development is identical ..Development on Windows..Production on Linux
MGWhen google routes me to Vladimir Putins site for Official Windows Mysql 
Stack you download god knows what
MGsolution is to give the customer an in-between solution such as mysqld, 
mysqladmin and mysql shell scripts that will work under Windows cygwin
MGThe Database Workbench version5 MySQL plugin README should detail *a 
seamless installation* for Windows cygwin
MGif I have to make changes to my.ini or etc/init.d the readme should be 
specific on what those changes should be
MGReadme should also be specific on how to successfully test mysql ports 
(presumably 3306)..i assume netstat -a | grep 3306?

MGThanks

Martin,

I have no idea what the above means --

Database Workbench is a client side Windows based database design and 
development tool,

no need to Cygwin or modify my.ini


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird! 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



ANN: database developer tool Database Workbench 5 now available

2014-09-04 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5

Upscene Productions is proud to announce the availability of
the next major version of the popular multi-DBMS development tool:

 Database Workbench 5 

There have been numerous improvements to existing tools and the new, more
consistent user interface is better than ever and works fine under Wine on 
Linux.

Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!



There is so much new in Database Workbench 5, I don't know where to start, 
says Martijn Tonies,
founder of Upscene Productions. This release adds code editor features, has 
diagramming improvements,
comes in multiple editions, is fully HiDPI aware and offers tunneling for MySQL 
and MariaDB connections.
It all was a lot of work, but it was worth it!

We worked closely with out customer and implemented many of their requests and 
for
new users, we offer multiple editions to suit their development needs. From 
design to
productivity, there's new features and improvements in almost everything!



For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed 
based on
selectable modules.


It includes tools for database design, database maintenance, testing, data 
transfer,
data import  export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 12 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

Re: Stored procedure debuggers

2014-08-21 Thread Martijn Tonies (Upscene Productions)

Hello Larry,



Subject: Stored procedure debuggers

Does anyone know of any debuggers for stored procs that run on Mac and/or
Linux?


Although all our tools are Windows tool, we have customers running Database 
Workbench

under Wine without major problems.

We have a standalone debugger tool called Hopper, I haven tried it under 
Wine yet, but

there's a good chance it runs fine.

Here's my latest (successful) attempt running Database Workbench under Wine, 
as a complete

Linux novice. ;)

http://www.upscene.com/support.php?page=dbw_ubuntu_wine


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: Cannot Update, at least not how I'm telling it to!

2014-07-09 Thread Martijn Tonies (Upscene Productions)

The AND in your UPDATE clause makes this a logical operator instead
of being a SQL keyword.

Your syntax is wrong:

UPDATE ...
SET mycol = value,
mycol2 = value
[WHERE ... ]

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

-Original Message- 
From: Surya Savarika 
Sent: Wednesday, July 09, 2014 3:56 PM 
To: mysql@lists.mysql.com 
Subject: Cannot Update, at least not how I'm telling it to! 


Hi.

mysql describe unions_data;
+-+-+--+-+-++
| Field   | Type| Null | Key | Default | Extra  |
+-+-+--+-+-++
| ID  | int(11) | NO   | PRI | NULL| auto_increment |
| Title   | varchar(70) | NO   | | NULL||
| Description | text| YES  | | NULL||
| UsersID | int(11) | NO   | MUL | NULL||
+-+-+--+-+-++
4 rows in set (0.02 sec)

mysql select * from unions_data;
++---+-+-+
| ID | Title | Description | UsersID |
++---+-+-+
|  4 | Union One | descr one   |   2 |
|  5 | Union Two | descr two   |   2 |
++---+-+-+
2 rows in set (0.00 sec)

mysql update unions_data set Title='Dos' and Description='dos' where ID=5;
ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'Dos'
mysql update unions_data set Title=2.2 and Description='dos' where ID=5;
Query OK, 1 row affected (0.33 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql select * from unions_data;
++---+-+-+
| ID | Title | Description | UsersID |
++---+-+-+
|  4 | Union One | descr one   |   2 |
|  5 | 0 | descr two   |   2 |
++---+-+-+
2 rows in set (0.00 sec)

Notice that it threw an error about an incorrect DOUBLE value for a
field that is a varchar. Notice that when it did decide to update, it
updated incorrectly and it updated Title but _not_ Description, yet
issued no Warnings. Am I missing something??
TIA,
Savi

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available!

2014-06-17 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available!

Ladies, gentlemen,

Upscene Productions is proud to announce the next version 
of the popular Windows-based multi-DBMS development tool:

 Database Workbench 4.4.7 Pro 


For more information, see http://www.upscene.com/go/?go=newsid=20140617



Database Workbench supports:
- Borland InterBase ( 6.x and up )
- Firebird ( 1.x and up )
- MS SQL Server/MSDE ( 7 and up )
- MySQL 4.x and up
- Oracle Database ( 8i and up )
- Sybase SQL Anywhere ( 9 and up )
- NexusDB ( 3.0 and up )


Thank you for your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Upscene Productions
http://www.upscene.com

ANN: Hopper - Stored Routine debugger - v1.5.1 released

2014-06-16 Thread Martijn Tonies (Upscene Productions)
ANN: Hopper - Stored Routine debugger - v1.5.1 released



Dear ladies and gentlemen,

Upscene Productions is proud to announce version 1.5.1 of our
product called Hopper.

Hopper is a Windows-based Stored Routine and Trigger Debugger, 
available for InterBase, Firebird and MySQL.

For more information, see http://www.upscene.com/go/?go=hopper


This release contains new features and bugfixes, see
http://www.upscene.com/go/?go=newsid=20140616
for more information.



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Three days left on the 75% FIFA World Cup Discount!

2014-06-09 Thread Martijn Tonies (Upscene Productions)
Dear reader,

There’s 3 days left on our FIFA World Cup special:

75% discount on all our database development products!

http://www.upscene.com/




With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com


ANN: 75% special FIFA World Cup 2014 discount on all our products

2014-05-26 Thread Martijn Tonies (Upscene Productions)
Hello everyone,

We’re currently offering a 75% discount on all our (Windows based) products!

This includes test data generator, development and debugging tools, feel free
to take a look at http://www.upscene.com



Thank you for your attention.



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com



ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available!

2014-04-29 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available!

Ladies, gentlemen,

Upscene Productions is proud to announce the next version 
of the popular Windows-based multi-DBMS development tool:

 Database Workbench 4.4.6 Pro 

For more information, see http://www.upscene.com/go/?go=newsid=20140429


The FREE Lite Editions will be released at a later stage.



Database Workbench supports:
- Borland InterBase ( 6.x and up )
- Firebird ( 1.x and up )
- MS SQL Server/MSDE ( 7 and up )
- MySQL 4.x and up
- Oracle Database ( 8i and up )
- Sybase SQL Anywhere ( 9 and up )
- NexusDB ( 3.0 and up )






Thank you for your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Upscene Productions
http://www.upscene.com

ANN: Hopper - Stored Routine debugger - v1.5.0 released

2014-04-01 Thread Martijn Tonies (Upscene Productions)
ANN: Hopper - Stored Routine debugger - v1.5.0 released



Dear ladies and gentlemen,

Upscene Productions is proud to announce version 1.5.0 of our
product called Hopper.

Hopper is a Windows-based Stored Routine and Trigger Debugger, 
available for InterBase, Firebird and MySQL.

For more information, see http://www.upscene.com/go/?go=hopper


This release contains new features and bugfixes, see
http://www.upscene.com/go/?go=newsid=20140401
for more information.



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

ANN: Database Workbench 4.4.5, special MySQL discount!

2014-03-19 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.5, the multi-DBMS IDE now available!

Ladies, gentlemen,

Upscene Productions is proud to announce the next version 
of the popular Windows-based multi-DBMS development tool:

 Database Workbench 4.4.5 Pro 


March only: 25% discount on Database Workbench Pro for MySQL
using discount coupon MYSQLSPECIAL - additional modules can be
purchased at a later stage.


For more information, see http://www.upscene.com/go/?go=newsid=20140319


The FREE Lite Editions will be released at a later stage.



Database Workbench supports:
- Borland InterBase ( 6.x and up )
- Firebird ( 1.x and up )
- MS SQL Server/MSDE ( 7 and up )
- MySQL 4.x and up
- Oracle Database ( 8i and up )
- Sybase SQL Anywhere ( 9 and up )
- NexusDB ( 3.0 and up )






Thank you for your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Upscene Productions
http://www.upscene.com

ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available!

2014-01-27 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available!

Ladies, gentlemen,

Upscene Productions is proud to announce the next version 
of the popular Windows-based multi-DBMS development tool:

 Database Workbench 4.4.4 Pro 



For more information, see http://www.upscene.com/go/?go=newsid=20140127


The FREE Lite Editions will be released at a later stage.



Database Workbench supports:
- Borland InterBase ( 6.x and up )
- Firebird ( 1.x and up )
- MS SQL Server/MSDE ( 7 and up )
- MySQL 4.x and up
- Oracle Database ( 8i and up )
- Sybase SQL Anywhere ( 9 and up )
- NexusDB ( 3.0 and up )






Thank you for your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Upscene Productions
http://www.upscene.com

ANN: Advanced Data Generator 3.2.0 released

2014-01-07 Thread Martijn Tonies (Upscene Productions)
ANN: Advanced Data Generator 3.2.0 released

Dear ladies and gentlemen,

Upscene Productions is happy to announce the next release
of their Windows based flexible and easy to use test data 
generator tool:

Advanced Data Generator 3.2.0 

A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, many filling options, presets and 
much more.

Version 3 included many new features, eg:
* Unicode support in an all new fresh user interface
* Ability to use external databases as the source for data
* New and improved data libraries for real life like data
* New template types
* Much improved documentation with comprehensive How to-section

This product comes in four versions:
- Pro: ADO and ODBC connectivity
- InterBase Edition
- Firebird Edition
- MySQL Edition

More info and a 30-day trial version on www.upscene.com

Pricing information available on:
http://www.upscene.com/go/?go=purchase

More information available here:
http://www.upscene.com/go/?go=newsid=20140107



With regards,

Martijn Tonies
Upscene Productions - Database Tools for Developers
http://www.upscene.com

ANN: Advanced Data Generator 3.1.2 released

2013-12-02 Thread Martijn Tonies (Upscene Productions)
ANN: Advanced Data Generator 3.1.2 released

Dear ladies and gentlemen,

Upscene Productions is happy to announce the next release
of their Windows based flexible and easy to use test data 
generator tool:

Advanced Data Generator 3.1.2 

A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, many filling options, presets and 
much more.

Version 3 included many new features, eg:
* Unicode support in an all new fresh user interface
* Ability to use external databases as the source for data
* New and improved data libraries for real life like data
* New template types
* Much improved documentation with comprehensive How to-section

This product comes in four versions:
- Pro: ADO and ODBC connectivity
- InterBase Edition
- Firebird Edition
- MySQL Edition

More info and a 30-day trial version on www.upscene.com

Pricing information available on:
http://www.upscene.com/go/?go=purchase

More information available here:
http://www.upscene.com/go/?go=newsid=20131202



With regards,

Martijn Tonies
Upscene Productions - Database Tools for Developers
http://www.upscene.com

ANN: Hopper - Stored Routine debugger - v1.4.1 released

2013-12-02 Thread Martijn Tonies (Upscene Productions)
ANN: Hopper - Stored Routine debugger - v1.4.1 released



Dear ladies and gentlemen,

Upscene Productions is proud to announce version 1.4.1 of our
product called Hopper.

Hopper is a Windows-based Stored Routine and Trigger Debugger, 
available for InterBase, Firebird and MySQL.

For more information, see http://www.upscene.com/go/?go=hopper


This release contains bugfixes, see
http://www.upscene.com/go/?go=newsid=20131202b
for more information.



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available!

2013-11-27 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available!

Ladies, gentlemen,

Upscene Productions is proud to announce the next version 
of the popular Windows-based multi-DBMS development tool:

 Database Workbench 4.4.3 Pro 

This release fixes a blocking problem after a recent Windows XP
security update.

There's a 15% autumn discount until the end of November!


For more information, see http://www.upscene.com/go/?go=newsid=20131127


The FREE Lite Editions are also updated, this includes several enhancements
compared to the previous available Lite Editions.



Database Workbench supports:
- Borland InterBase ( 6.x and up )
- Firebird ( 1.x and up )
- MS SQL Server/MSDE ( 7 and up )
- MySQL 4.x and up
- Oracle Database ( 8i and up )
- Sybase SQL Anywhere ( 9 and up )
- NexusDB ( 3.0 and up )






Thank you for your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Upscene Productions
http://www.upscene.com

ANN: Database Workbench 4.4.2, the multi-DBMS IDE now available!

2013-10-24 Thread Martijn Tonies (Upscene Productions)
Ladies, gentlemen,

Upscene Productions is proud to announce the next version 
of the popular Windows-based multi-DBMS development tool:

 Database Workbench 4.4.2 Pro 


There's a 15% autumn discount until the end of November!


This release includes enhancements and fixes several bugs as reported by our 
users.

For more information, see http://www.upscene.com/go/?go=newsid=20131024

The FREE Lite Editions will follow later.







Database Workbench supports:
- Borland InterBase ( 6.x and up )
- Firebird ( 1.x and up )
- MS SQL Server/MSDE ( 7 and up )
- MySQL 4.x and up
- Oracle Database ( 8i and up )
- Sybase SQL Anywhere ( 9 and up )
- NexusDB ( 3.0 and up )






Thank you for your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Upscene Productions
http://www.upscene.com

ANN: Advanced Data Generator 3.1.1 released

2013-10-14 Thread Martijn Tonies (Upscene Productions)
ANN: Advanced Data Generator 3.1.1 released

Dear ladies and gentlemen,

Upscene Productions is happy to announce the next release
of their flexible and easy to use test data generator tool:
Advanced Data Generator 3.1.1 

A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, many filling options, presets and 
much more.

Version 3 included many new features, eg:
* Unicode support in an all new fresh user interface
* Ability to use external databases as the source for data
* New and improved data libraries for real life like data
* New template types
* Much improved documentation with comprehensive How to-section

This product comes in four versions:
- Pro: ADO and ODBC connectivity
- InterBase Edition
- Firebird Edition
- MySQL Edition

More info and a 30-day trial version on www.upscene.com

Pricing information available on:
http://www.upscene.com/go/?go=purchase

More information available here:
http://www.upscene.com/go/?go=newsid=20131014



With regards,

Martijn Tonies
Upscene Productions - Database Tools for Developers
http://www.upscene.com

ANN: Hopper - Stored Routine debugger - v1.4.0 released

2013-10-09 Thread Martijn Tonies (Upscene Productions)
ANN: Hopper - Stored Routine debugger - v1.4.0 released



Dear ladies and gentlemen,

Upscene Productions is proud to announce version 1.4.0 of our
product called Hopper.

Hopper is a Windows-based Stored Routine and Trigger Debugger, 
available for InterBase, Firebird and MySQL.

For more information, see http://www.upscene.com/go/?go=hopper


This release contains bugfixes and improvements, see
http://www.upscene.com/go/?go=newsid=20131009
for more information.



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com