DevHeads.net

Database

Watch 2012 Northern Trust Open Live Online TV Stream golf

Watch 2012 Northern Trust Open Live Online TV Stream golf
2012 0Northern Trust Open
Match Scheduled 16-19th February 2012
Pacific Palisades, California
Purse: $6,600,000
PGA Tour
when will start 2012 Northern Trust Open Live streaming online tv golf match.It will be held on 16th February 2012 and end 19th February 2012.And how can watch 2012 Northern Trust Open online streaming live match.In the world 2012 Northern Trust Open golf streaming PGA Tour are famous to all golf faners.
2012 Northern Trust Open Live Online

Watch Porto vs Manchester City Live Stream Free Soccer Online

Watch Porto vs Manchester City Live Stream Free Soccer Online
Porto vs Manchester City
Match Scheduled 16-02-2012 from 3:05pm (US/Eastern)
Location Estádio Do Dragão (Porto)
UEFA Europa League
Porto vs Manchester City team are known to all soccer faners in the world.UEFA Europa League live streaming soccer match Porto vs Manchester City match is very exciting.
Watch Porto vs Manchester City Live

<a href="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/" title="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/">http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stre...</a>

^^**wAtcH^^**Aston Villa vs Manchester City Live Stream Soccer Online February 12, 2012

wAtcH Barclays Premier League between Aston Villa vs Manchester City live stream
Are you looking for Aston Villa vs Manchester City Free live streaming link? Then you have come to the correct place. You can watch a live online stream of Aston Villa vs Manchester City right here. The is no need to look anywhere else. The links for the event appear above.

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

Rule module implementation Bug problem

Hi Dear,
I have a doubt regarding following procedure , it work fine in Article but not
in "Page" creation (I mean the link is not proper), please help me with a
solution , pls follow the steps and try to create an article and basic page
and click the status link , you got my problem .

To display an 'Add More [Content_type]' link after user saves new content, do the following:

1. Go to admin/config/workflow/rules
2. Click Add New Rule
3. At admin/config/workflow/rules/reaction/add, give your new Rule a name, something like

'Add more content link'

Optimize fails due to duplicate rows error but no duplicates found

Good day guys,

I am hoping this mail finds you well.

I am at a bit of a loss here...

We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed.

However, after running for over an hour , the optimize fails stating there is a duplicate entry in the table.

We have now spent 2 days using various methods but we are unable to find any duplicates in the primary key and also nothing on the unique key fields.

Any idea on why optimize would still be failing ?

Regards

PostgreSQL) How to use Bind Variable with ODBC Driver V10?

Hello. 

I hope my email finds you well. 

I am developing query tool for PostgreSQL using ODBC Driver (recent release ODBC v10).

The product that I am developing uses the SQLDescribeParam() function before the query SQLExec() when using Bind Variable. 

SQLDescribeParam () function normally works on 'psqlodbc_09_06_0500-x86', when using Bind Variable. 

However, in 'psqlodbc_10_00_0000-x86' and later versions, error occurs and Bind Variable cannot be used. 

Normal queries that do not use the SQLDescribeParam () function work fine. 

For your reference, below is the example of the query that

NUMERIC type makes trouble in MS Access

Hi there,

I'm experiencing problems with the ODBC driver on Windows 7 (and 10)
on 32 and 64 bit in Microsoft Access 2003, 2010 and 2016 (32, 64 bit).

My PostgreSQL server runs on Debian (64-bit): 9.6.7-1.pgdg80+1
Tested ODBC drivers: psqlodbc_09_06_0500 & psqlodbc_10_01_0000

Summary of the problem:
The current behavior of the ODBC driver creates an error in Access,
since the incoming values are longer than the field type. This leads
into a truncation warning (with many messageboxes) and no values
are shown at all.

Patch for an encoding bug in the derive_locale_encoding function

Hello!

I've found a bug while I was working with the driver.

Mroonga 8.00 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.00 has been released!
This is a major version up! But It keeps backward compatibility.
You can upgrade to 8.0.0 without rebuilding database.

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

ANN: Upscene releases Database Workbench 5.4.0

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.

MySQL Connector/Python 8.0.6-rc has been released

Dear MySQL users,

MySQL Connector/Python 8.0.6-rc is the first release candidate version
of the MySQL Connector Python 8.0 series. This series adds support for
the new X DevAPI. The X DevAPI enables application developers to write
code that combines the strengths of the relational and document models
using a modern, NoSQL-like syntax that does not assume previous
experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/" title="http://dev.mysql.com/doc/x-devapi-userguide/en/">http://dev.mysql.com/doc/x-devapi-userguide/en/</a>.

MySQL Cluster 7.6.4-dmr has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.6.4-dmr, has been released and can be downloaded from

<a href="http://www.mysql.com/dow" title="http://www.mysql.com/dow">http://www.mysql.com/dow</a>

ODBC - Retrieving info messages - RAISE NOTICE

Hi,

When executing a PL/pgsql query using powershell with ODBC (yes, a somehow special setup), it is possible to register to the event "InfoMessage" (with Register-ObjectEvent) to retrieve all messages that are created for example by using "RAISE NOTICE".
While this works fine when using MS SQL and the SqlConnection (all print statements are retrieved), it does not work with Postgres and the OdbcConnection, here, only the last message ("3") is retrieved, when a statement like
DO $$
RAISE NOTICE '1';
RAISE NOTICE '2';
RAISE NOTICE '3';
END$$;
is executed.

Maybe this is a general constraint wh

MySQL Connector/Java 8.0.9-rc has been released

Dear MySQL users,

MySQL Connector/Java 8.0.9-rc is the first Release Candidate
of the 8.0 branch of MySQL Connector/J, providing an insight into
upcoming features. It is suitable for use with MySQL Server versions
5.5, 5.6, 5.7, and 8.0.

MySQL Connector/Net 8.0.10-rc has been released

Dear MySQL users,

MySQL Connector/Net 8.0.10 is the first release candidate of MySQL
Connector/Net to add support for the new X DevAPI. The X DevAPI enables
application developers to write code that combines the strengths of the
relational and document models using a modern, NoSQL-like syntax that
does not assume previous experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html" title="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html">http://dev.mysql.com/doc/x-devapi-userguide/en/index.html</a>.

Mroonga 7.11 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.11 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

statement timeout with psqlODBC 09.05.300+

Hi,

This ticket is related to
<a href="http://www.postgresql-archive.org/BUG-odbc-statement-timeout-gets-set-to-30000-td5992591.html" title="http://www.postgresql-archive.org/BUG-odbc-statement-timeout-gets-set-to-30000-td5992591.html">http://www.postgresql-archive.org/BUG-odbc-statement-timeout-gets-set-to...</a>

The client using the ODBC Driver is on Windows 7, must be x86 compatible,
and connect to a 9.6 postgresql database.
from 09.05.300+ version of the ODBC driver x86 (tested up to 10.01), queries
which used to work fine with drivers 08.x now throw "ERROR: canceling
statement due to statement timeout;"

It seems that there is now a default setting for statement timeout coming
with 9.5+ versions of the driver (less than 1 mn), and I did not find any
way to change this settin

MySQL Community Server 8.0.4-rc has been released (part 3/3)

[If you just recived an email with 8.0.3-rc in the title, please
ignore that. Sorry for the confusion]

* For builds on 32-bit platforms with Undefined Behavior
Sanitizer enabled, a stack-overrun check could cause a
server exit. (Bug #27224961)

* The server could hang during spatial reference system
(SRS) creation while another session was using that SRS.
(Bug #27220467)

* A lock for the privilege cache was acquired unnecessarily
during privilege-checking operations not involving table
permissions.

MySQL Community Server 8.0.3-rc has been released (part 3/3)

* For builds on 32-bit platforms with Undefined Behavior
Sanitizer enabled, a stack-overrun check could cause a
server exit. (Bug #27224961)

* The server could hang during spatial reference system
(SRS) creation while another session was using that SRS.
(Bug #27220467)

* A lock for the privilege cache was acquired unnecessarily
during privilege-checking operations not involving table
permissions.

MySQL Community Server 8.0.4-rc has been released (part 2/3)

Bugs Fixed

* Important Change: The following changes are made to the
PERIOD_ADD() and PERIOD_DIFF() functions:

+ A period value used with one of these functions may
not be negative.

+ The month part of a period value may not be equal to
0.
A period value used with one of these functions for which
at least one of these conditions is true now causes the
function to fail with an error.

MySQL Community Server 8.0.4-rc has been released (part 1/3)

[Due to size limitations, the announcement is split in 3. This is part 1.]

MySQL Server 8.0.4-rc (Release Candidate) is a new version of the world's
most popular open source database.

MySQL Cluster 7.4.19 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.4 makes significant advances in performance;
operational efficiency (such as enhanced reporting and faster restarts
and upg

MySQL Cluster 7.4.18 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.4 makes significant advances in performance;
operational efficiency (such as enhanced reporting and faster restarts
and upg

Java threads waiting on Mysql connections, but Mysql shows no evidence of this

I posted this question on StackOverflow, here's a link to my question:
<a href="https://stackoverflow.com/questions/48388562/java-threads-waiting-" title="https://stackoverflow.com/questions/48388562/java-threads-waiting-">https://stackoverflow.com/questions/48388562/java-threads-waiting-</a>
on-mysql-connections-but-mysql-shows-no-evidence-of-this

In summary, my java code is waiting for a connection indefinitely, but
mysql doesn't seem to show this is the case. I'd appreciate if someone
could answer on the stackoverflow post. Thanks!

Examples of savepoints and transactions

Hi,
I have a system that uses begin and commit transactions. It works like a dream! ;)
Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for rolling back test data is to use savepoints and rollback. I think it is hard to find examples of this scenario. Are there some good guides or tutorials out there somewhere? Any suggestions are welcome.

Best regards
Lars Nielsen

MySQL Connector fails on non existing function with NullPointerException

I'm seeing a failure in the MySQL JDBC Connector with some tests of ours.

Can't get my query to return wanted data

Hi
I am running mysql 5.7.20 in ubuntu linux 17.10

I have 2 tables, member and status with contents like

member:
ident, given, surname
1 fred jones
2 john howard
3 henry wales
4 jenny brown

status:
ident year
1 2017
2 2017
3 2017
4 2017
1 2018
3 2018

I want my query to return the name and ident from the member table for all
members that has not got an entry in status with year=2018

I have been working on the following query to achieve this, but it only
returns data when there is no `year` entries for a selected year.

MySQL Cluster 7.3.20 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.3.20, has been released and can be downloaded from

<a href="http://www.mysql.com/downlo" title="http://www.mysql.com/downlo">http://www.mysql.com/downlo</a>

MySQL Cluster 7.5.9 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.5.9, has been released and can be downloaded from

  <a href="http://www.mysql.com/down" title="http://www.mysql.com/down">http://www.mysql.com/down</a>

MySQL Community Server 5.6.39 has been released

Dear MySQL users,

MySQL Server 5.6.39, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.39 is
recommended for use on production systems.

For an overview of what's new in MySQL 5.6, please see

<a href="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html" title="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html">http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html</a>

Starting with 5.6.11, Microsoft Windows packages for MySQL 5.6
are available both as a "full" installer and as a "web" installer.
The full installer is significantly larger and comes bundled with
the latest software releases available.

MySQL Community Server 5.7.21 has been released

Dear MySQL users,

MySQL Server 5.7.21, a new version of the popular Open Source
Database Management System, has been released.

Bug in is_setting_search_path

Hello,

I have found a bug in the is_setting_search_path function (connection.c line 1597).

The search loop is currently:

for (; *q; q++)
{
if (IS_NOT_SPACE(*q))
{
if (strnicmp(q, "search_path", 11) == 0)
return TRUE;
q++;
while (IS_NOT_SPACE(*q))
q++;
}
}

The inner while(IS_NOT_SPACE(*q)) loop will terminate if a null is reached.

In MySQL 8.0, how does one recognize roles?

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
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

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

Mroonga 7.10 - Fast fulltext search for all languages on,MySQL

Hi,

Mroonga 7.10 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

RE: psqlODBC 10.01.0000 Released -- what about 9.6.6?

Hi,

I can see that the 09.06.0500 driver disappeared from <a href="https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/" title="https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/">https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/</a>
Will it be back? Will there be an update for PostgreSQL 9.6.6?

Q: OPTIMIZE TABLE - internal error 122 during operation

Hello,

We have an NDB cluster and we experience 'mysterious' database-full errors.

Our setup is the following:

- server_mgm: Management Node
- server_1: Data Node 1
- server_2: Data Node 2

(Host names are explanatory.)

config.ini:

[NDBD DEFAULT]
NoOfReplicas=2
MaxNoOfExecutionThreads=4
DataMemory=6G
IndexMemory=1G
LockPagesInMainMemory=1
# tuning
MaxNoOfConcurrentTransactions = 8192
MaxNoOfConcurrentOperations = 65536
MaxNoOfConcurrentScans = 500
# end of tuning

[NDB_MGMD]
NodeId=1
HostName=server_mgm

[NDBD]
NodeId=11
HostName=server_1
DataDir=/var/lib/mysql-cluster
StopOnErro

psqlODBC 10.01.0000 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 10.01.0000.
please see the notes at:
<a href="https://odbc.postgresql.org/docs/release.html" title="https://odbc.postgresql.org/docs/release.html">https://odbc.postgresql.org/docs/release.html</a>

psqlODBC may be downloaded from in source, Windows Installer,
merge module, and basic zip file formats.

New Windows installer installs both 32-bit and 64-bit driver at once
on 64-bit OS.

Memory leak when using SQLParamData and SQLPutData

Hi,

When executing a prepared insert statement and using SQL_DATA_AT_EXEC parameters that will be sent with SQLParamData and SQLPutData, the driver will leak memory for parameters. The memory will not be deallocated not even the handles are freed and the program disconnects from the database.

I am attaching a small project to demonstrate the bug. You can also browse the project at <a href="https://hub.darcs.net/mihaigiurgeanu/psqlodbc-insert-leak" title="https://hub.darcs.net/mihaigiurgeanu/psqlodbc-insert-leak">https://hub.darcs.net/mihaigiurgeanu/psqlodbc-insert-leak</a>

Thanks,
Mihai

MS Access adds always actual day in time defined postgres column

Hallo,

We are moving BackEnd tables from a large MS Access application to postgresql.

In one table we have a field "Zeit" defined in postgres as

time(0) without time zone DEFAULT ('now'::text)::time(0) without time zone,

The linked table inside Access shows the actual day in front of the time value. Using the 24-hour format for displaying time values in Access looks fine.

回复:Re: Sharding key of secondary index with respect to sharding key of the table and shard by range?

Thanks Mauritz.

Here is what I understand you ( all for NDB engine ):
1. No requirement for partitioning columns to be included in secondary indexes, regardless of unique index or non-unique index.
2. For any secondary indexes, there are usually two parts, one is as hash index, another is a tree index. The hash index is sharded independently, so any updates involving secondary index will usually require distributed transaction, so a performance penalty. The tree part of a secondary index is co-located with main table, and is not co-located with the hash part.

Sharding key of secondary index with respect to sharding key of the table and shard by range?

I have two questions, related.
1. As far as I know, mysql has support for secondary index, which is good, but how does mysql shard a secondary index. The doc says secondary index is implemented as index table, then is the index table sharded independently of the main table?

Mroonga 7.09 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.09 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

Migration to PGLister - After

Greetings!

This list has now been migrated to new mailing list software known as
'PGLister'.

Migration to pglister - Before

Greetings,

We will be migrating these lists to pglister in the next few minutes.

This final email on the old list system is intended to let you know
that future emails will have different headers and you will need to
adjust your filters.

The changes which we expect to be most significant to users can be found
on the wiki here: <a href="https://wiki.postgresql.org/wiki/PGLister_Announce" title="https://wiki.postgresql.org/wiki/PGLister_Announce">https://wiki.postgresql.org/wiki/PGLister_Announce</a>

Once the migration of these lists is complete, an 'after' email will be
sent out.

Thanks!

Stephen

BUG: odbc statement_timeout gets set to 30000

Hi All

I've found a problem with at least the 906 and 1000 odbc driver, in that, no
matter what statement_timeout is set to, after initially connecting and
setting the value to that specified in the connection settings, it is then
subsequently set to 30000.

This means that queries running longer than 30seconds are failing, which is
a major problem.

session_timeout being set to 30000 bug

Hi All

OK,I've been trying out the later odbc drivers, 906 and 1000.

MySQL Workbench 6.3.10 GA has been released

Dear MySQL users,

The MySQL developer tools team announces 6.3.10 as our GA release for
MySQL Workbench 6.3.

For the full list of changes in this revision, visit
<a href="http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html" title="http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html">http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html</a>

For discussion, join the MySQL Workbench Forums:
<a href="http://forums.mysql.com/index.php?152" title="http://forums.mysql.com/index.php?152">http://forums.mysql.com/index.php?152</a>

Download MySQL Workbench 6.3.10 GA now, for Windows, macOS 10.11+,
Oracle Linux 7, Fedora 26 and 27, Ubuntu 16.04 and 17.10
or sources, from:

<a href="http://dev.mysql.com/downloads/tools/workbench/" title="http://dev.mysql.com/downloads/tools/workbench/">http://dev.mysql.com/downloads/tools/workbench/</a>

Enjoy!

Changes in MySQL Workbench 6.3.10 (2017-11-15)
Bugs Fixed

* Performance

API changes report for MySQL Connector/J

Hi,

I'd like to share report on API changes and backward compatibility for the MySQL Connector/J library: <a href="https://abi-laboratory.pro/java/tracker/timeline/mysql-connector-java/" title="https://abi-laboratory.pro/java/tracker/timeline/mysql-connector-java/">https://abi-laboratory.pro/java/tracker/timeline/mysql-connector-java/</a>

BC — binary compatibility
SC — source compatibility

The report is generated by the <a href="https://github.com/lvc/japi-tracker" title="https://github.com/lvc/japi-tracker">https://github.com/lvc/japi-tracker</a> tool for jars at <a href="http://central.maven.org/maven2/mysql/mysql-connector-java/" title="http://central.maven.org/maven2/mysql/mysql-connector-java/">http://central.maven.org/maven2/mysql/mysql-connector-java/</a>. The tool checks for API changes according to the article <a href="https://wiki.eclipse.org/Evolving_Java-based_APIs_2" title="https://wiki.eclipse.org/Evolving_Java-based_APIs_2">https://wiki.eclipse.org/Evolving_Java-based_APIs_2</a>.

Hope it will be helpful for users and maintainers of the library.

Thank you.

Trying to replicate from MS 2008 R2 to PostgreSQL

I have a project where I am trying to replicate some tables from a MS2008 SQL database to a PostgreSQL database. I have created a Linked Server using the PostgreSQL ANSI driver and the connection tests successfully. But when I try to create a subscription using that Linked Server, I cannot connect successfully to it. I was wondering if you might have some insights into possible avenues of research for this problem.

Problem with ODBC v.10

Hello,

We use msaccess that connects to postgresql database with your ODBC driver

With the new version 10.0, something does not work anymore :

When we create a new record in a table with the dao method tb.addnew

Then we want to get the Autonumber generated, we used to add tb.update
and tb.Bookmark=tb.LastModified and then we were able to get the
tb!MyAutoNumberField value

Now this does not wok anymore and we get The record is deleted

(note that with MSAccess database we can get the autonumber before the
tb.update)

I saw that you have changed things with Identity...

SQL ODBC Interface Developer opportunity in Livermore CA

SQL Database ODBC Developer

Convergence CT (www.convergencect.com<http://www.convergencect.com>) is a global health information company founded in 2001
and based in Honolulu Hawaii with the goal of connecting technologies to manage and use big data
to the benefit of patients, healthcare providers, researchers, and life science companies.

SQL ODBC interface developer opportunity in Livermore CA

SQL ODBC Interface Developer position

Convergence CT (<a href="http://www.convergencect.com" title="www.convergencect.com">www.convergencect.com</a>) is a global health information company founded in 2001 and based in Honolulu Hawaii with the goal of connecting technologies to manage and use big data to the benefit of patients, healthcare providers, researchers, and life science companies. CCT has implemented over 27 clinical data warehouse systems for 76 hospitals and medical groups in Japan, Taiwan, China, Canada and the United States.

monitoring mysql performance

Hi,

I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with
MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using
innodb.

So I´m thinking of ways of improving MySQL performance and of course
for that, you need to measure.

Currently I´m checking, there are no slow queries and read and writes
perform well.

Mroonga 7.07 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.08 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

ANN: Upscene releases Database Workbench 5.3.4

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 Ups

MySQL Connector/Net 6.9.10 has been released

Dear MySQL users,

MySQL Connector/Net 6.9.10 is a maintenance release for the 6.9.x
series of the .NET driver for MySQL.

ANN: Stored routine debugger Hopper, version 2.0 released

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. <a href="http://www.upscene.com/stored_procedure_debugger/" title="http://www.upscene.com/stored_procedure_debugger/">http://www.upscene.com/stored_procedure_debugger/</a>

About Hopper
Hopper is a stored routine debugging tool for MySQL, Firebird and InterBase.

How to get the MySQL Command-Line Tool to display Unicode properly

I use a Python program to write text containing Unicode characters to a
MySQL
database.  As an example, two of the characters are

    u'\u2640' a symbol for Venus or female
    u'\u2642' a symbol for Mars or male

I use utf8mb4 for virtually all character sets involved with MySQL.  Here is
an excerpt from /etc/mysql/my.cnf

    [client]
    default-character-set=utf8mb4

    [mysql]
    default-character-set=utf8mb4

    [mysqld]
    character-set-server =utf8mb4

I'm not sure that the [client] option does anything, but it doesn't seem to
hurt.

In addition, all tables are created wi

MySQL Cluster 7.3.19 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geographic replication

- 99.999% High Availability with no single point of failure
and on-line maintenance
- NoSQL and SQL APIs (including C++, Java, http, Memcached
and JavaScript/Node.js)

MySQL Cluster 7.3.19, has been released and can be downloaded from

<a href="http://www.mysql.com/downlo" title="http://www.mysql.com/downlo">http://www.mysql.com/downlo</a>

MySQL Cluster 7.4.17 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.4 makes significant advances in performance;
operational efficiency (such as enhanced reporting and faster restarts
and upg

Syndicate content