Infrastructure at your Service
Now that we have a system with a proper network setup we can take a look at how backup and restore works in Exasol. Without being able to restore and recover your database, you for sure cannot put a system into production, so backup and restore always is a major topic to understand (with any system that holds data you do not want to lose). When it comes to backup and restore, this is what…
Initially I wanted to write about Backup and Restore of Exasol databases but I quickly ran into issues, and this is the reason why this post is coming first. When you import the Exasol Community OVA as described in the first post, the VM is running with host only adapters and you can not connect to anything outside the Exasol system. This is however required if you want to store the backups outside the cluster….
By Franck Pachot . Statistically, my blog posts starting with a single SQL keyword (like COMMIT and ROLLBACK) in the title are not fully technical ones, but about moves. Same here. It is more about community engagement, people sharing. And about a friend. And clusters of course… In 2020 because of this COVID virus, we try to avoid clusters of people. And everybody suffers from that in the community because we have no, or very…
This is Part II of a tour of rlwrap for idql/iapi. For Part I, please follow the link here. Enhanced output visualization This is one rlwrap’s most fantastic enhancement. It is not that different from what I suggested here only much smoother. idql does not provide any flexible formatting and lines longer than the screen width get wrapped around, which results in hard to read output. rlwrap’s pipeto filter lets redirect this output to another…
The rant I have a confession to make: I’m obsessed with idql/iapi. These tools so central to Documentum administrative tasks are so lame for interactive work that they have probably disgusted more than their share of administrators. The problem is that I have to use them almost daily, and everyday I grumble: there must be a better way. Sure, there were third-party utilities such as Samson and Repoint in the past, and now dqman and…
Column formatting was always a pain in sqlplus when writing queries on the prompt. Most people use tools like SQL Developer or Quest TOAD which can scroll horizontally when running queries against a database, but as a consultant you are often still forced to use sqlplus. Here’s the issue: When running e.g. a query on a table T1 (which is a copy of ALL_OBJECTS) it looks by default as follows and is hard to read:…
This is the fourth post in the series about Exasol and this time it is about sessions and auditing. If you are interested in the previous posts you can find them here: Getting started with Exasol – Setting up an environment Getting started with Exasol – Loading data from PostgreSQL Getting started with Exasol – Some words about indexes and transactions
If you followed Getting started with Exasol – Setting up an environment and Getting started with Exasol – Loading data from PostgreSQL you should have an Exasol test system up and running and a virtual schema pointing to a PostgreSQL schema. What we’ll be doing in this post is to load the data from PostgreSQL into Exasol and then have a look at how transactions work in Exasol and how Exasol is handling indexes.
By Franck Pachot . My first attempt to connect to an Oracle database from a Jupyter Notebook on Google Colab was about one year ago: https://medium.com/@FranckPachot/a-jupyter-notebook-on-google-collab-to-connect-to-the-oracle-cloud-atp-5e88b12282b0 I’m currently preparing a notebook as a handout from my coming SQL101 presentation where I start with some NoSQL to discover the benefits of RDBMS and SQL. I’m running everything on the Oracle Database because it provides all APIs (NoSQL-like key-value, with SODA, documents with OSON, and of course…
In the first post of this series we brought up an Exasol test system to have something to play with. Because playing without data is a bit boring this post is about loading data from PostgreSQL to Exasol. We’ll use pgbench on the PostgreSQL side to generate some data and then load that into Exasol.
Exasol is an in memory database with parallel processing, or shorter MPP(Massively Parallel Processing) database. I got in touch with some people from Exasol at the DOAG 2019 in Nuremberg but never had the time to take a closer look since then. Over the past few weeks however I finally had the chance to get in touch with the system and thought it might be a good idea to share what I learned by writing…
By Franck Pachot . I may have mentioned in some previous blog post that, in my opinion, the names of Oracle Database features make sense on the vendor product management context more than in a user context. I’m not saying that it is good or bad. There are so many features, that can be combined, and that evolved for many years. The possible use cases is unlimited. What I see customers doing in Europe is…
