Search for a command to run...
šHi, my name is Siddhant.
š©āš»I am a Software Engineer. I am passionate about technology, and coding. āI also like to read and write about technology and productivity.
In my free time, I play guitaršø and also like to play badmintonšø.
No comments yet. Be the first to comment.
Every distributed system eventually faces this question: How many requests can we safely handle? Rate limiting is often treated as a simple middleware feature ā add a token bucket, set 100 requests/minute, and move on. But in production systems ā e...
Hello everyone!This blog is a follow-up to my previous post, āElevate Your Styling with SASSā, where I explained the advantages of using SCSS over traditional CSS. In this post, Iāll walk you through how to effectively integrate SCSS into a ReactJS p...
Introduction Hello everyone! Today, I am going to show you how you can create a table in ClickHouse from a CSV using Python. We use WSL to run ClickHouse on Windows. If you want to know how to run ClickHouse on Windows locally, you can check this art...
Hello everyone, Have you ever needed to stage only specific files in Git but found it tedious to manually copy and paste file paths, especially when they are in different folders? If so, I have a simple solution for you! Iāve created a Bash script th...
Last October, I took on the challenge of solving a LeetCode problem every day for a month and announced it on Twitter. After completing the first month, I decided to extend the challenge for another month. What began as a 30-day commitment eventually...
Hello everyone! In this post, I will demonstrate how to run ClickHouse locally on Windows.
To run ClickHouse, we need a Linux environment. Therefore, we will download WSL (Windows Subsystem for Linux), enabling us to run a Linux environment on Windows.
Open Command Prompt in administrator mode by right-clicking and selecting "Run as administrator." Then, type the command "wsl --install."
wsl --install
You will see something like this
After that, you will need to create a Linux user and set a password for that user. Create a user with any name you want and set a password that you will remember, as you may need this password for installing any other libraries in your subsystem.
Now run the below command to install ClickHouse
curl https://clickhouse.com/ | sh
./clickhouse server
./clickhouse client
There you go, you can now run ClickHouse on your local machine.
Let's create a new table. Run the below query to create a table.
CREATE TABLE TEST
(
`userId` UInt64,
`name` String,
`password` String,
`description` Nullable(String)
)
ENGINE = MergeTree
ORDER BY tuple()
Let's see if we get the table created. To see the list of tables in our ClickHouse client run the below query.
SHOW TABLES
Now, let's insert some data in the table.
INSERT INTO TEST (*) FORMAT Values
(1, 'Siddhant', 'password', 'test description'),
(2, 'user2', 'password2', 'test description 2'),
(3, 'user3', 'password3', 'test description 3')
To see the data run select the query
SELECT * FROM TEST
You will see the following result
At the end of each query, ClickHouse shows how much time it took to process the given query. Additionally, it displays how many rows ClickHouse processed per second to execute the query.
This is how you can run ClickHouse locally. Please let me know if this blog was helpful, and if you have any doubts, write them down in the comments section. I will do my best to answer them.
More about clickhouse:
https://blog.siddhantbobde.com/clickhouse-csv-ingestion-with-python-explicit-schema