Tag: MariaDB Server

Feed: MariaDB Knowledge Base Article Feed. Author: . mariadb_schema is a data type qualifier that allows one to create MariaDB native date types in a SQL_MODE that has conflicting data type translations. mariadb_schema was introduced in MariaDB versions 10.3.24, 10.4.14, 10.5.5. For example in SQL_MODE=ORACLE, if one creates a table with the DATE type, it will actually create a DATETIME column to match what an Oracle user is expecting. To be able to create a MariaDB DATE in Oracle mode one would have to use mariadb_schema: CREATE TABLE t1 (d mariadb_schema.DATE); mariadb_schema is also shown if one creates a table ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Operators basically instruct Kubernetes about how to manage a certain technology. Kubernetes comes with some default operators, but it is possible to create custom operators. Operators created by the community can be found on OperatorHub.io. Custom Operators Kubernetes provides a declarative API. To support a specific (i.e. MariaDB) technology or implement a desired behavior (i.e. provisioning a replica), we extend Kubernetes API. This involves creating two main components: A custom resource. A custom controller. A custom resource adds an API endpoint, so the resource can be managed via the API server. It ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Config File Location The kernel can be configured via a JSON file called mariadb_config.json. The kernel will look for this config file in one of these two locations: If the JUPYTER_CONFIG_DIR environment variable is defined (non-empty) mariadb_kernel will try to read $JUPYTER_CONFIG_DIR/mariadb_config.json If the env variable is empty, the kernel will try to read $HOME/.jupyter/mariadb_config.json Config Example Here’s an example file containing some of the available options that you can pass to the kernel: cat ~/.jupyter/mariadb_config.json { "user": "root", "host": "localhost", "port": "3306", "password": "securepassword", "start_server": "True", "client_bin": "/usr/bin/mariadb", "server_bin": "/usr/bin/mariadbd" } ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . If you installed the kernel, installed its kernelspec and you have MariaDB installed on your system, you just need to open JupyterLab, and when you create a new notebook, pick MariaDB as your kernel. For some example notebooks, check out the notebooks directory in our GitHub repository page, those should guide through what you can do with mariadb_kernel. You can also try mariadb_kernel using the amazing MyBinder platform by accessing this link or you can click on the Try MariaDB @ binder badge from the mariadb_kernel GitHub repo. This takes absolutely no ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The mariadb_kernel project is made out of several components. These components were created to perform various functions such as: interfacing with the Jupyter protocol API, parsing the input texts that the user writes in the notebook cells, magic commands execution or even just abstracting away certain interactions that we suspect might change in the future. Here’s a diagram displaying the relationship between all the main components of the kernel. When you start a notebook in JupyterLab, Jupyter spawns an instance of MariaDBKernel. The kernel then creates a ClientConfig object to read mariadb_config.json ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . LibreOffice Base is free to use RDBMS (relational database management system) front-end tool to create and manage various databases. Prepare ODBC connection Before going further make sure to prepare an ODBC connector as explained on MariaDB ODBC connector article. That includes: Download MariaDB ODBC connector (latest version 3.1.7-ga) Copy shared library libmaodbc.so to /usr/lib/[multi-arch] Install unixodbc, unixodbc-dev, openssh-client, odbcinst packages Create template file for ODBC driver, example for template file “MariaDB_odbc_driver_template.ini” could be: [MariaDB ODBC 3.1 Driver] Description = MariaDB Connector/ODBC v.3.1 Driver = /usr/lib/x86_64-linux-gnu/libmaodbc.so Install ODBC driver from template file running: ... Read More

Feed: Clustrix Blog. Author: Rob Hedgpeth. Today, we’re excited to announce our new MariaDB Reactive Relational Database Connectivity (R2DBC) connector is GA. The connector implements the most recent R2DBC 0.8.3 specification which provides a non-blocking, fully-reactive API used to communicate with relational sources. The JDBC API, made available through MariaDB Connector/J, has long been a popular choice among Java developers for creating applications that connect to and communicate with MariaDB. However, with the introduction of MariaDB’s new R2DBC driver, developers now have the ability to interact with MariaDB databases completely non-blocked through the use of asynchronous data streams. While it’s ... Read More

Feed: Clustrix Blog. Author: Rasmus Johansson. MariaDB Connector/C++ is now a release candidate (RC). C++ is known for its efficiency, versatility and extensibility, and it is often used in industries like fintech where applications require predictable concurrency and latency. Now, C++ developers can use the native MariaDB Connector/C++ to connect their applications to MariaDB Server on premises and in the cloud on MariaDB SkySQL. MariaDB Connector/C++ is available from the MariaDB Download page (choose “C++ connector”). MariaDB Enterprise Documentation includes instructions for installing and using Connector/C++. MariaDB Connector/C++ is a release candidate (RC) release. It is not recommended for production ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Overview MindsDB is a third-party application that interfaces with MariaDB Server to provide Machine Learning capabilities through SQL. The interface is done via the Connect Storage Engine. Installation To get a functional MariaDB - MindsDB installation, one needs to install the following components: MindsDB connects to MariaDB Server via a regular user to setup a dedicated database called mindsdb. Which user will be used is specified within MindsDB's configuration file. For example, if MindsDB is installed locally, one can create a user called mindsdb@localhost. MindsDB only authenticates via the mysql_native_password plugin, hence ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB starting with 10.4.3Support for application-time period-versioning was added in MariaDB 10.4.3. Extending system-versioned tables, MariaDB 10.4 supports application-time period tables. Time periods are defined by a range between two temporal columns. The columns must be of the same temporal data type, i.e. DATE, TIMESTAMP or DATETIME (TIME and YEAR are not supported), and of the same width. Using time periods implicitly defines the two columns as NOT NULL. It also adds a constraint to check whether the first value is less than the second value. The constraint is invisible to SHOW ... Read More