Skip to Content
E-Learning

Tutorials

Practical tutorials for the work we actually do. Pick one, read it in order, and apply it.

Any category Programming2 Python 1 SQL 1
Any topics APIs and Integrations 5 Automation and Scripting 3 Data Structures and Algorithms 4 Databases 11 Deployment and Containers 11 Object-Oriented Programming 4 Packaging and Dependencies 10 Performance Optimization 2 Programming Basics 2 Programming Patterns 2 Security 2 Testing and Debugging 12 Type Systems 11 Web Development 12
Any level Beginner 1 Intermediate 2 Advanced 24
Performance Optimization Intermediate Clear filters 2 results
0 likes
Reading a Large Text File in Python Line by Line

for line in file reads one line at a time, so a 10 GB file uses almost no memory. read() and readlines() load everything. Count, filter and stop early without building a list, and read in blocks when there are no lines.

6 min read
0 likes
Paginate Without OFFSET

Page through a table with keyset pagination: filter on the last row you showed and add a tie-breaker. After this, a later page costs the same as the first and rows do not repeat or vanish between pages.

4 min read