01-05-2021



Install Aplikasi DBeaver di Ubuntu. Lebakcyber.net – Cara Install Aplikasi DBeaver di Ubuntu. Pada kesempatan kali ini kita akan membahas mengenai bagaimana cara untuk melakukan instalasi dan juga konfigurasi aplikasi DBeaver di Ubuntu. DBeaver CE (Community Edition) merupakan sebuah aplikasi gratis dan juga open source SQL client yang didesain bagi para developer, analis, programmer SQL. DBeaver is free and open source universal database tool for developers and database administrators. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc. Usability is the main goal of this project, program UI is carefully designed and implemented.

Dbeaver Apache Drill

Dbeaver apache drill
  • Dark theme support was improved (Windows 10 and GTk)
  • Data viewer:
    • Copy As: format configuration editor was added
    • Extra configuration for filter dialog (performance)
    • Sort by column as fixed (for small fetch sizes)
    • Case-insensitive filters support was added
    • Plaintext view now support top/bottom dividers
    • Data editor was fixed (when column name conflicts with alias name)
    • Duplicate row(s) command was fixed for multiple selected rows
    • Edit sub-menu was returned to the context menu
    • Columns auto-size configuration was added
    • Dictionary viewer was fixed (for read-only connections)
    • Current/selected row highlighting support was added (configurable)
  • Metadata search now supports search in comments
  • GIS/Spatial:
    • Map position preserve after tiles change
    • Support of geometries with Z and M coordinates was added
    • Postgis: DDL for 3D geometry columns was fixed
    • Presto + MySQL geometry type support was added
    • BigQuery now supports spatial data viewer
    • Binary geo json support was improved
    • Geometry export was fixed (SRID parameter)
    • Tiles definition editor was fixed (multi-line definitions + formatting)
  • SQL editor:
    • Auto-completion for objects names with spaces inside was fixed
    • Database objects hyperlinks rendering was fixed
  • SQL Server: MFA (multi-factor authentication) support was added
  • PostgreSQL: array data types read was fixed
  • Oracle: indexes were added to table DDL
  • Vertica: LIMIT clause support was improved
  • Athena: extra AWS regions added to connection dialog
  • Sybase IQ: server version detection was improved
  • SAP ASE: user function loading was fixed
  • Informix: cross-database metadata read was fixed
  • We migrated to Eclipse 2021-03 platform
DbeaverDbeaver appDbeaver altibase

Dbeaver Appimage

Dbeaver

Dbeaver Aptos

Hi All, I'wrote a class to connect to MSSQL/Azure databases with Transaction support.
Hope this can help anyone!
<?php
/**
* @author Johan Kasselman <johankasselman@live.com>
* @since 2015-09-28 V1
*
*/
class pdo_dblib_mssql{
private
$db;
private
$cTransID;
private
$childTrans = array();
public function
__construct($hostname, $port, $dbname, $username, $pwd){
$this->hostname = $hostname;
$this->port = $port;
$this->dbname = $dbname;
$this->username = $username;
$this->pwd = $pwd;
$this->connect();
}
public function
beginTransaction(){
$cAlphanum = 'AaBbCc0Dd1EeF2fG3gH4hI5iJ6jK7kLlM8mN9nOoPpQqRrSsTtUuVvWwXxYyZz';
$this->cTransID = 'T'.substr(str_shuffle($cAlphanum), 0, 7);
array_unshift($this->childTrans, $this->cTransID);
$stmt = $this->db->prepare('BEGIN TRAN [$this->cTransID];');
return
$stmt->execute();
}
public function
rollBack(){
while(
count($this->childTrans) > 0){
$cTmp = array_shift($this->childTrans);
$stmt = $this->db->prepare('ROLLBACK TRAN [$cTmp];');
$stmt->execute();
}
return
$stmt;
}
public function
commit(){
while(
count($this->childTrans) > 0){
$cTmp = array_shift($this->childTrans);
$stmt = $this->db->prepare('COMMIT TRAN [$cTmp];');
$stmt->execute();
}
return
$stmt;
}
public function
close(){
$this->db = null;
}
public function
connect(){
try {
$this->db = new PDO ('dblib:host=$this->hostname:$this->port;dbname=$this->dbname', '$this->username', '$this->pwd');
} catch (
PDOException $e) {
$this->logsys .= 'Failed to get DB handle: ' . $e->getMessage() . 'n';
}
}
}
?>