Archive for category TOI

Getting started with VR Table Tennis

Difficult to play table tennis in real life (IRL) these days. I found this simulation:

Eleven TT is really close to IRL table tennis – I’m a club player myself and I was surprised how close this comes to reality! Check this YouTube channel to get an idea about the quality of the simulation. The guy who uploads these videos might be a bit too competitive sometimes, but he’s clearly a good player and challenges the best available opponents regularly.

The game itself costs 20 Euro, which is a real bargain for the great quality you get. Many will have no VR headset, though, and that’s a bit more expensive. I recommend the Oculus Quest 2 that works autonomously without a workstation and without wires. That’s about 400 Euro.

As IRL player, you will want to transfer as much of your skills as possible, which is why a paddle adapter is helpful. I recommend the Sanlaki F8 adapter.

They sell them, but also provide the 3d printer files for free so you can print it yourselves or let someone else print it for you. I ordered mine for 15 Euro (shipping included) via Treatstock (Black PLA, 20% fill) and find it quite useful.

So overall, you have to spend about 500 Euro to get started, but it’s totally worth it in my opinion:

A TT table + ballmachine would cost you more (if you have the space to place it at home). That is included in the game, as well as an AI opponent with configurable levels. That alone is worth it already. Given the choice, I’d favor the simulation over the IRL ballmachine – and I had one before, so I can compare.

In multiplayer mode, you can play against other human opponents across the world. Whenever you want to play table tennis, you’ll find an opponent without having to leave the comfort of your home. And you will never have to pick up a ball from the floor again 😉

Leave a comment

Elevate your IT career with free certifications from #Exasol!

Exasol is the fastest analytics database. It is rapidly spreading worldwide. Exasol knowledge is in high demand therefore. You can get it for free from us here: training.exasol.com

We provide free online learning courses to cope with our rapid growth – these scale better than instructor-led training. Our courses are short and to-the-point: Exasol doesn’t need extensive training because it’s easy to work with. It delivers outstanding performance with very low maintenance. Our database is designed to take care of itself to a large degree. That’s why each of our few courses can be completed within one day.

Exasol certification exams are charged with 150 Euro per attempt. We decided now to grant one free attempt per course. For you, that means you can get fully Exasol certified for free – if you prepare well for the exams.

Good luck with that, we love to see you succeed 🙂

Some feedback we got from attendees:

“I liked the training very much. It was clearly structured, easy to follow and very interesting. I liked the quizzes and hands-on. Very good job.”

“With over 9 years of experience in Oracle technologies, Exasol was quite new for me but the precise course content and availability of Community Edition of Exasol made learning smooth.”

“Thank you #Exasol for offering free high-quality courses!”

“It was insightful to go deep into Exasol database architecture and perceive what makes Exasol world’s fastest analytics database. Kudos to the Exacademy team for awesome training content.”

“Thank you Exasol for offering this great (free!) training experience!”

“I enjoyed exploring distributed in-memory database Exasol. I liked comprehensive auto-tuning features those reduces maintenance hassles and let you focus on Analytics. It was a great learning experience, and I got the chance to sharpen distributed design skills and pick up a few new ones along the way.”

“Did Exasol Certified Associate!!! Great Experience… Thanks Exasol!”

“Successfully completed ‘Exasol 6 Certified Professional Administrator’. Proud to be an Exasol Certified Professional!! It was a great learning journey.”

“This time, I was learning about #Exasol – the high-performance, cloud-first analytics database. Why? Well, got the idea from my colleague, who did it first, and I thought – why not… it’s an opportunity to learn something new! It was fun learning, going through the nice material and especially doing the hands-on labs.”

,

Leave a comment

Run #Python directly in the database

With Python integrated to the database, you can utilize the power of SQL together with one of the most popular programming languages. And you run the program where the data is: Inside the database. Instead of having to bring the data to the program.

The Exasol database integrates the popular programming languages Python, Java and R as UDF scripting languages, together with the less known but powerful and elegant programming language Lua.

Let’s look at an example how Python can be used in Exasol, together with SQL:

--/
create or replace python3 scalar script find_books(keyword varchar(2000000)) emits (title varchar(2000000)) as
import urllib.request
import urllib.parse
import json 
import ssl
ssl._create_default_https_context = ssl._create_unverified_context def run(ctx): with urllib.request.urlopen('https://www.googleapis.com/books/v1/volumes?maxResults=40&q='+ urllib.parse.quote_plus(ctx.keyword)) as url: s = url.read() data = json.loads(s) for item in data["items"]: ctx.emit(item["volumeInfo"]["title"]) /

We’re using the free google api here to access book titles. That script is then called like this:

select find_books('discworld');

How about sorting that list after length of title? That’s something SQL can do very well:

select length(title), title from (select find_books('discworld')) order by 1;

This should give you an idea about the endless and powerful options you have by combining Python with SQL, both integrated in the database.

By the way: We’re happy to educate you on this for free with our online learning course Exasol Advanced Analytics 🙂

Leave a comment

%d bloggers like this: