Some Notes on SQLAlchemy

Recently, I have been collecting and processing a large amount of data, which usually involves converting XML/text format data into relational, structured data for easy export and direct analysis, especially formats that can be directly analyzed by pandas (csv/json). Therefore, I need to use a mysql processing library in Python. Since I was looking for a processing library, I decided to go all out and choose a library that supports ORM. So, I chose SQLAlchemy. After using it for a while, I decided to write a record to remember the commonly used things during this period.

SQLAlchemy is an open-source software under the Python programming language. It provides an SQL toolkit and Object-Relational Mapping (ORM) tools, mainly to meet the following needs:

  • Provide common operations on databases: add, delete, modify, and query
  • Provide ORM functionality, which can turn the operating unit into an object, so there is no need to write sql statements for hard coding/decoding parsing data

Summary of Automate the Boring Stuff with Python

This book is about how to automate work with Python and where it can be applied. It is aimed at non-programmers who want to increase productivity and reduce repetitive work. As a future programmer, why do I recommend this book aimed at non-programmers? In my view, code is a tool. As a tool, it should be used to help solve problems and meet needs. However, in many of our coding-related learning, we don't consider why, but simply learn what. This learning method is not efficient, and the most critical thing is that there will be a sense of confusion about what it is used for/whether it is useful, thereby losing the motivation to continue learning. Therefore, I recommend this book, starting from the demand, using the demand as the goal, telling you what you can do, and you don't have to learn the specific use part in order, you can jump to the relevant part based on the demand after mastering certain basic syntax.

Summary of Ultralearning

This article is a summary of the new book "Ultralearning" by Scott Young, a blogger I greatly admire. The book mainly introduces the related concepts and principles of ultralearning. Definition What is ultralearning? Literally, it's ultra + learning, which can be understood as learning beyond the ordinary. The definition given in the book is: A strategy for acquiring skills and knowledge that is both self-directed and intense strategy: It's a learning strategy (just a strategy, not a necessity) self-directed: Self-guided (self-arranged/planned) intense: High intensity Overall, this is more like a learning methodology. Talent is not necessary (of course, having talent will inevitably enhance the effect), anyone can do it, and it can cultivate good learning methods/habits/attitudes/concepts. Principle Looking at all the ultralearners the blogger has encountered, what makes them so successful in learning? The author has summarized 9 guiding principles through many examples. These are the essence of the book, explaining the important factors associated with ultralearning.