Categories

How to work with MS Access under Unix

Introduction

Many companies use MS Access even until now. From time to time, someone want to connect to an ancient database. Moreover they want to extract data from there and to make this within standard Unix-based server. Of course, this data needed for an web application. And therefore someone want to use data from...

How to work with MS Access under Unix

Introduction

Many companies use MS Access even until now. From time to time, someone want to connect to an ancient database. Moreover they want to extract data from there and to make this within standard Unix-based server. Of course, this data needed for an web application. And therefore someone want to use data from...

Details about MSSQL FDW and query speedup ways

Introduction

Here I want to describe in details a FDW for MSSQL and several aproaches to speedup of queries over external tables. If in short: I want to say about follows:

• differences between major versions of TDS FDW,

• compatibility issues of FreeTDS and MSSQL.
• approach to a query-optimization in case...

Details about MSSQL FDW and query speedup ways

Introduction

Here I want to describe in details a FDW for MSSQL and several aproaches to speedup of queries over external tables. If in short: I want to say about follows:

• differences between major versions of TDS FDW,

• compatibility issues of FreeTDS and MSSQL.
• approach to a query-optimization in case...

Details about MSSQL FDW and query speedup ways

Introduction

Here I want to describe in details a FDW for MSSQL and several aproaches to speedup of queries over external tables. If in short: I want to say about follows:

• differences between major versions of TDS FDW,

• compatibility issues of FreeTDS and MSSQL.
• approach to a query-optimization in case...

Interesting tasks from technical interviews

This is a repost of my article from Medium. Also, here is a russian variant.

I visited lots of interviews and was on a both sides of this standoff. Now I want to share most interesting tasks with other. Because I believe, that interview must be interesting and rememberable, not awful and demotivating.

<h2…

Interesting tasks from technical interviews

This is a repost of my article from Medium. Also, here is a russian variant.

I visited lots of interviews and was on a both sides of this standoff. Now I want to share most interesting tasks with other. Because I believe, that interview must be interesting and rememberable, not awful and demotivating.

<h2…

How to fix wifi and bluetooth on Beelink S12 Pro?

UPD: finally, it works out of box the for kernel 6.1.158 (debian 6.1.0-41-rt-amd64). Try the latest kernel first!

Problems and fixes

Well known, Intel doesn’t like Unix. Beelink S12 is not an exception. Wi-Fi might work on a latest Ubuntu kernels. But if you’re using something like Debian 12 (Bookworm) you will have a problem.

As was mentioned...

How to compile linux kernel with some patches?

Unfortunately, my nettop candidate (Beelink Mini S12 Pro) for CNC mill has a problem with Wi-Fi on Debian 12. This is common for intel PC and there is a wide range of solutions in the Internet. For my particular case there is a good kernel patch on AskUbuntu. Also, there are more details for those who want to...

How to fix wifi and bluetooth on Beelink S12 Pro?

UPD: finally, it works out of box the for kernel 6.1.158 (debian 6.1.0-41-rt-amd64). Try the latest kernel first!

Problems and fixes

Well known, Intel doesn’t like Unix. Beelink S12 is not an exception. Wi-Fi might work on a latest Ubuntu kernels. But if you’re using something like Debian 12 (Bookworm) you will have a problem.

As was mentioned...

How to compile linux kernel with some patches?

Unfortunately, my nettop candidate (Beelink Mini S12 Pro) for CNC mill has a problem with Wi-Fi on Debian 12. This is common for intel PC and there is a wide range of solutions in the Internet. For my particular case there is a good kernel patch on AskUbuntu. Also, there are more details for those who want to...

How to compile linux kernel with some patches?

Unfortunately, my nettop candidate (Beelink Mini S12 Pro) for CNC mill has a problem with Wi-Fi on Debian 12. This is common for intel PC and there is a wide range of solutions in the Internet. For my particular case there is a good kernel patch on AskUbuntu. Also, there are more details for those who want to...

How to fix wifi and bluetooth on Beelink S12 Pro?

UPD: finally, it works out of box the for kernel 6.1.158 (debian 6.1.0-41-rt-amd64). Try the latest kernel first!

Problems and fixes

Well known, Intel doesn’t like Unix. Beelink S12 is not an exception. Wi-Fi might work on a latest Ubuntu kernels. But if you’re using something like Debian 12 (Bookworm) you will have a problem.

As was mentioned...

Homming setup on LinuxCNC

In general, there is a good article about homing configuration. Therefore, I don’t want to repeat it. I just want to share a personal experience and caveats.

Homing is not so straightforward as it might seem. It’s vary depends on installation and hardware.

Lack of tweaks

Might be needed some tweaks to make it works properly. But LinuxCNC...

Shielded ethernet cable and Mesa

tl;dr: use only shielded ethernet cable (not U/UTP), Cat doesn’t matter.

Why shielded?

Because of EMI.

In my case exactly the same setup: the same wires, the same Mesa board together with the same PC works fine while locates fare from garage. E.g. max ping latency mentioned before is ~300us. But when I moved the setup to...

PID tuning in LinuxCNC

There are many articles about PID tuning in general and about LinuxCNC in particular. For example, here is a good article about PID tuning and man page with more nitty-gritty details or even source code with the most intimate details. That is why below will be only my personal experience together with a couple practical tips which...

Wireless MPG controller setup (xhc-whb04b)

Now a day most popular wireless MPG controller is XHC-WHB04B-6.

There is a man page on LinuxCNC, but not all details are well explained. In particular, for my GMOCCAPY GUI it doesn’t work out of the box. Therefore, I’ll provide a bit more details about setup.

First of all, here are couple useful links:

• LinuxCNC forum thread...

Remote desktop on LinuxCNC

In general, this looks like a good idea. Especially for debugging sessions. Because not always convenient to sit next to machine for hours. Instead, will be good to sit in a more comfortable place and tweak/debug it remotely.

Yes, you might be in trouble if something goes wrong and you’ll be unable to switch it off instantly. Therefore, I’m not...

How to reduce jitter on LinuxCNC?

You know, jitter is a key metric for CNC controller. The lower the jitter, the smoother the machine will operate. However, this is not always obvious how to lower it to achieve something less than 50k. Especially under a full load. Here are some tips with rough estimation of its impact.

Important: jitter/latency and the system performance are opposite things....

How to reduce jitter on LinuxCNC?

You know, jitter is a key metric for CNC controller. The lower the jitter, the smoother the machine will operate. However, this is not always obvious how to lower it to achieve something less than 50k. Especially under a full load. Here are some tips with rough estimation of its impact.

Important: jitter/latency and the system performance are opposite things....

How to reduce jitter on LinuxCNC?

You know, jitter is a key metric for CNC controller. The lower the jitter, the smoother the machine will operate. However, this is not always obvious how to lower it to achieve something less than 50k. Especially under a full load. Here are some tips with rough estimation of its impact.

Important: jitter/latency and the system performance are opposite things....

Remote desktop on LinuxCNC

In general, this looks like a good idea. Especially for debugging sessions. Because not always convenient to sit next to machine for hours. Instead, will be good to sit in a more comfortable place and tweak/debug it remotely.

Yes, you might be in trouble if something goes wrong and you’ll be unable to switch it off instantly. Therefore, I’m not...

Wireless MPG controller setup (xhc-whb04b)

Now a day most popular wireless MPG controller is XHC-WHB04B-6.

There is a man page on LinuxCNC, but not all details are well explained. In particular, for my GMOCCAPY GUI it doesn’t work out of the box. Therefore, I’ll provide a bit more details about setup.

First of all, here are couple useful links:

• LinuxCNC forum thread...

PID tuning in LinuxCNC

There are many articles about PID tuning in general and about LinuxCNC in particular. For example, here is a good article about PID tuning and man page with more nitty-gritty details or even source code with the most intimate details. That is why below will be only my personal experience together with a couple practical tips which...

Shielded ethernet cable and Mesa

tl;dr: use only shielded ethernet cable (not U/UTP), Cat doesn’t matter.

Why shielded?

Because of EMI.

In my case exactly the same setup: the same wires, the same Mesa board together with the same PC works fine while locates fare from garage. E.g. max ping latency mentioned before is ~300us. But when I moved the setup to...

Homming setup on LinuxCNC

In general, there is a good article about homing configuration. Therefore, I don’t want to repeat it. I just want to share a personal experience and caveats.

Homing is not so straightforward as it might seem. It’s vary depends on installation and hardware.

Lack of tweaks

Might be needed some tweaks to make it works properly. But LinuxCNC...