Database

Install DB Browser for SQLite 3.9.0 on Ubuntu 16.04

DB Browser for SQLite 3.9.0 which was released end of last year is now available for installation via the PPA. SQLite Browser is a visual tool used to create, design and edit database files compatible with SQLite. This release contains some important enhancements, and fixes. SQLite Browser 3.9.0 Changelog Major Features Strong encryption is now supported on Windows, using SQLCipher! – 5d98a19 Keyboard navigation in the “Browse Data” tab now works well Our releases are now digitally signed on both Windows and MacOS Enhancements Add Fedora install instructions Add Windows DATE display format Remove ampersands from windows title Feature request: Option to turn off “intellisense”-like suggestions Add select and deselect all options for Export SQL dialog Add Homebrew Cask install instructions Add decimal support to display format Add Edit Database Cell update when selecting a cell from the Execute SQL tab Cannot view binary data on BLOB columns containing image Update Fedora install instructions Add preference setting for exports line ending Adjust executable/app name according to the project’s name Add duplicate record option Change default button to No in removal message dialogs Add default field type preference setting See changelog for more Install SQLite Browser 3.

Install SQLite Browser 3.8 on Ubuntu 16.04 and Derivatives

In this tutorial, we’re going to show you how to Install SQLite Browser 3.8 on Ubuntu 16.04 and Derivatives. SQLite Browser 3.8.0 which was released end of last year is now available for installation via the PPA. SQLite Browser is a visual tool used to create, design and edit database files compatible with SQLite. This release contains some important enhancements, and fixes. Install SQLite Browser 3.8 on Ubuntu 16.04 and Derivatives SQLite Browser 3.

Scylla 1.0.1 The world’s fastest NoSQL database released

Scylla 1.0.1 recently released, is the world’s fastest NoSQL database store compatible with Apache Cassandra. Scylla will work with existing Cassandra CQL clients. However, mixed clusters of Scylla and Cassandra nodes are not supported. A Scylla node cannot join a Cassandra cluster, and a Cassandra node cannot join a Scylla cluster. This release is a bug fixing release of Scylla 1.0 stable branch. 1.0.1. Scylla 1.0.1 Changelog An error message generated when a malformed SSTable is read may be formatted incorrectly in Scylla 1.

MongoDB 3.0.8 released

MongoDB 3.0.8 recently released, is an open-source, document-oriented database designed for ease of development and scaling. Think of MySQL but with JSON-like objects comprising the data model, rather than RDBMS tables. Significantly, MongoDB supports neither joins nor transactions. 3.1.7 is a development release and is not intended for production use. The 3.1 series will evolve into 3.2, which will be for production. MongoDB 3.0.8 Major Changes Security SERVER-21278 Remove executable bit from mongod.

Oracle Linux 7.2 released ships with Unbreakable Enterprise Kernel (UEK) Release 3

Oracle Linux 7.2 recently released, is the second update release for Oracle Linux 7 Update 2. A notable feature in this release is MySQL 5.6 Community Edition can now be installed directly with the Anaconda installer or kickstart. Oracle Linux 7 Update 2 ships with the following kernel packages: Red Hat Compatible Kernel (kernel-3.10.0-327.el7) for x86-64 Unbreakable Enterprise Kernel (UEK) Release 3 (kernel-uek-3.8.13-98.7.1.el7uek) for x86-64 By default, both the Unbreakable Enterprise Kernel and the Red Hat Compatible Kernel are installed and the system boots the Unbreakable Enterprise Kernel.

MySQL 5.7 General Availability released, 3x faster than MySQL 5.6

Oracle recently announced the general availability of MySQL 5.7, the latest version of the world’s most popular open source database. MySQL 5.7 delivers greater performance, scalability and manageability, plus enhanced NoSQL capabilities with JSON support and MySQL Router, which makes it easy to connect applications to multiple MySQL databases. “MySQL 5.7 delivers a wide range of innovations allowing developers, database administrators and DevOps teams to build and manage next-generation Web and cloud-based applications capable of processing ever increasing volumes of data,” said Tomas Ulin, vice president, MySQL Engineering, Oracle.

DBeaver 3.4.5 Universal Database Manager Released

DBeaver 3.4.5 recently released, is free and open source universal database tool for developers and database administrators. DBeaver is based on opensource framework and allows writing of various extensions (plugins). It supports any database having a JDBC driver. There is a set of plugins for certain databases (MySQL and Oracle in version 1.x) and different database management utilities (e.g. ERD). DBeaver supports the following databases: MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Sybase, ODBC, Java DB (Derby), Firebird (Interbase), SQLite, and many more.

MongoDB 3.0.6 is released

MongoDB 3.0.6 recently released, is an open-source, document-oriented database designed for ease of development and scaling. Think of MySQL but with JSON-like objects comprising the data model, rather than RDBMS tables. Significantly, MongoDB supports neither joins nor transactions. 3.1.7 is a development release and is not intended for production use. The 3.1 series will evolve into 3.2, which will be for production. MongoDB 3.0.6 Major Changes Improvements to WiredTiger Stability SERVER-19751, SERVER-19673, and SERVER-19573.

MariaDB 10.0.20 and 5.5.45 MySQL branch released

The MariaDB project recently announced the immediate availability of MariaDB 10.0.20 and 5.5.45. These are both Stable (GA) releases. MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB 5.5.45 is a maintenance release. It includes several bugfixes and updates, including from MySQL 5.5.45. MariaDB 10.0.21 changes XtraDB updated to XtraDB-5.6.25-73.1 Innodb updated to InnoDB-5.6.26 Performance Schema updated to 5.

PostgreSQL 9.4.2, 9.3.7, 9.2.11, 9.1.16 & 9.0.20 Released!

The PostgreSQL Global Development Group has released an update with multiple functionality and security fixes to all supported versions of the PostgreSQL database system, which includes minor versions 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20. The update contains a critical fix for a potential data corruption issue in PostgreSQL 9.3 and 9.4; users of those versions should update their servers at the next possible opportunity. Data Corruption Fix For users of PostgreSQL versions 9.

DB Browser for SQLite 3.5.0 released with support for encrypted databases

SQLite 3.5.0 Database Browser recently released, is a visual tool used to create, design and edit database files compatible with SQLite. One of the major improvements in this release, is support for encrypted databases (for MacOS X and Linux only, not Windows yet). This is done using the SQLCipher encryption library. SQLite Database Browser 3.5.0 update Enhancements I18N – Simplified Chinese language support Add tooltip for all table items Remember CSV export options Distinguish Save and Save As when saving SQL files in the Execute SQL tab Add support for compiling on OS/2 Add two buttons to navigate to the head and the tail Compatibility with shadow build Support Indices without sorting – FreeBSD Port Enhancements with progress, though more still needs to be done Open Encrypted Database Add full support for tables without rowid NULL field values are not highlighted Ability to change language Bug fixes Foreign Key in Edit Create Table CSV export bug – Fields aren’t automatically quoted when separator character is present in the data [feature request]”Execute SQL”: clear output if query returns nothing Export to SQL INT Datatype Expression Crash when opening db without rowid and composite primary key Database Structure view: wrong parsing of CHECK constraints tests: fix QCoreApplication parameters Other notes The Windows release uses SQLite v3.

MongoDB 3.0 released

MongoDB 3.0 recently released, is an open-source, document-oriented database designed for ease of development and scaling. Think of MySQL but with JSON-like objects comprising the data model, rather than RDBMS tables. Significantly, MongoDB supports neither joins nor transactions. The key features in this latest release include support for the WiredTiger storage engine, pluggable storage engine API, SCRAM-SHA-1 authentication mechanism, and improved explain functionality. MongoDB Ops Manager, which includes Automation, Backup, and Monitoring, is now also available.

Adminer 4.2.0 – Database Management released

Adminer (formerly known as phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL,Oracle, SimpleDB, Elasticsearch and MongoDB. Adminer 4.2.0 changelog Fix XSS in login form (bug #436) Allow limiting number of displayed rows in SQL command Fix reading routine column collations Unlock session in alter database Make master key unreadable to others (bug #410) Fix edit by long non-utf8 string Specify encoding for PHP 5.

OrientDB 2.0 released

After 6 months of Development and Testing, 400+ Issues resolved, 55 Pull Requests from the Community, 3 Milestones and 2 Release Candidates, Orient Technologies is thrilled to announced the final release of OrientDB 2.0! OrientDB 2.0 is much faster than 1.7 (many users notice a 40% performance improvement) and performs much better when distributed on multiple servers. The new Binary Protocol compresses the database size resulting in less space used on the File System and higher I/O throughput.

MySQL Cluster NDB 7.3.8 released

MySQL Cluster NDB 7.3.8 has just been released and its based on MySQL Server 5.6 and including features from version 7.3 of the NDB storage engine, as well as fixing a number of recently discovered bugs in previous MySQL Cluster releases. This release also incorporates all bugfixes and changes made in previous MySQL Cluster releases, as well as all bugfixes and feature changes which were added in mainline MySQL 5.6 through MySQL 5.

Influxdb 0.8.5 released

InfluxDB 0.8.5 recently released, is a time series, events, and metrics database. It’s written in Go and has no external dependencies. Influxdb enables you collect data on any interval and compute rollups on the fly later. InfluxDB contains a number of functions that you can use for computing aggregates, rollups, or doing downsampling on the fly. InfluxDB features a SQL like query language, only used for querying data. The HTTP API has endpoints for writing data and performing other database administration tasks.

RethinkDB 1.15.0 released

RethinkDB is an open-source, distributed database built to store JSON documents and effortlessly scale to multiple machines. It’s easy to set up and learn and features a simple but powerful query language that supports table joins, groupings, aggregations, and functions. RethinkDB Features Simple programming model: JSON data model and immediate consistency. Distributed joins, subqueries, aggregation, atomic updates. Secondary, compound, geospatial, and arbitrarily computed indexes.

MySQL Workbench 6.2.3 GA released

MySQL Workbench 6.2 is the new version for the official MySQL graphical development tool. MySQL Workbench 6.2 focuses on support for innovations released in MySQL 5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5. MySQL Workbench features A new spatial data viewer, allowing graphical views of result sets containing GEOMETRY data and taking advantage of the new GIS capabilities in MySQL 5.7. Support for new MySQL 5.

MySQL 5.6.21 released

MySQL is the world’s most popular open source database, enabling the cost-effective delivery of reliable, high-performance and scalable Web-based and embedded database applications. MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python.” Free-software-open source projects that require a full-featured database management system often use MySQL.

Install SQLite Database Browser 3.2.0 on Ubuntu 14.04

SQLite Database Browser is a visual tool used to create, design and edit database files compatible with SQLite. Its interface is based on QT, and is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. SQLite Database Browser 3.2.0 update Add keyboard shortcuts for saving changes and for executing a SQL statement Add High DPI text rendering support for Mac OSX Remember column widths on Browse Data tab?

How to change Zabbix database password

In this post, I will show you 2 simple steps on how to change the zabbix DB password from “zabbix” to something else. This comes in handy when you are running zabbix in a LIVE environment and you want to secure the DB connection password. Step 1. Update zabbix_server.conf & zabbix.conf.php configuration files – Log into zabbix, enter the command “vi /etc/zabbix/zabbix_server.conf” to edit the zabbix_server.conf file. Locate the line DBPassword= and change the password.

Add additional SQL instance to existing SQL Server 2008 R2 Cluster

This post will be focused on how to add additional SQL instance to an existing SQL Server 2008 R2 Cluster. At first I was a little confused about the concept of Active/Active and Active/Passive and its relationship with SQL failover clustering. In a multi failover cluster instances, these terms can be seen as ambiguous when used to describe the configuration of the SQL Server instances and the nodes they are running on.