Things I've learned, collected in stefanzweig/scratch.
Browse by topic: ahk 1 · cmake 1 · datasette 4 · developmemt 1 · django 3 · emacs 3 · git 1 · gitlab 1 · linux 1 · minikube 1 · podcast 1 · powershell 1 · python 2 · reading 1 · sqlite 3 · vim 1 · windows 1 · xmake 1
My xmake's version is xmake v2.9.8+20250321, which runs in the ubuntu 20.04. …
In a CSV file, if a column contains numbers with commas (e.g., "1,000"), and the quote marks, I am using emacs to covert it into a recognizable numeric format. …
To find the location of the package datasette-publish-vercel and replace it with datasette_publish_vercel in the vercel_cli.py file, you can firstly define the function as the following code: …
To remove the folder, use the following statements: …
Click Win+r and run the following command. …
I am using org mode for note taking. Sometimes I write python code in babel block. …
I want to insert all the csv files in the folder into the tabel mytable. …
I am using xubuntu in my old MacBook Air with an external monitor. the window manager is i3wm. The first workspace lies in internal display which make me hard to check where my mouse is. So I have to configure all the workspaces are shown in the external monitor. the tool of the multiple monitor control is xrandr. …
Nowadays I am working on a project running both on linux and on windows. I have to compile some libs with cmake. On ubuntu the compiler by default is the gcc, while in windows the toolchain is quite complicated that msvc is used by default. I need compile the lib with mingw64 toolchain. I have to configure the cmake's Makefile to use gcc. …
The script is as below. …
Function date can add some offsets in query statement. …
In metadata.yml, …
SQLite-utils can clean the data in the database.db. …
SQLite with memory can be used to handled the big data in csv format. …
TBD. …
We install the gitlab-runner on ubuntu server. …
To set the size of the frame, using the following statements: …
Two packages to define classes and attributes. …
Curl the link and get the data, passing it to the sqlite-utils with memory - option to analyse data, following a sql statement. …
Bulk create the data at a time. …
I saw a table in a page in which a link is in a column of each row. I need to snap all the links. What I did is as the following. …
I need to run the job at several time points in the day. The solution is comma-split string in the register_job decorator. …
link: https://stackoverflow.com/questions/7811556/ …
Link: https://thesephist.com/posts/how-i-side-project/ …
Link: https://talkpython.fm/home …
There are several developers in my team. Our project is being developed with django framework. All the backend guys have their local development database and they manage their own database migration files. They do not commit the migration files to version control. This is quite good but some guy has the bad habbit not fix the migration problem of default value. Others have to fix the problem when they pull the model changes back. …
I met a problem this morning. Some guy in my team deleted some database migration files by accident a few days ago. And I can't remember the files's contents. …
Today I learned that if you hit Esc in vim and then type :set mouse=a and hit enter... vim grows mouse support! In your terminal! …