Tagged articles
COPY
29 articles · Page 1 of 1
The article explains that whether adding an index locks a MySQL table depends on the version and DDL algorithm—MySQL 5.5 and earlier lock the whole table, 5.6‑5.7 use Online DDL with brief metadata locks, and 8.0+ can create secondary indexes instantly without locking, while primary, unique, and full‑text indexes always require locking.
COPYINPLACEINSTANT
0 likes · 10 min read

This article walks through a real iOS crash caused by mutating an NSMutableSet during enumeration, explains how the Objective‑C copy attribute works, compares shallow and deep copies for strings and collections, and shows the underlying runtime implementation with concrete code examples.
COPYNSMutableSetObjective-C++
0 likes · 17 min read

This article introduces Python’s shutil module and demonstrates how to copy, move, rename, archive, and delete files and directories with concise code examples while highlighting important safety considerations.
COPYarchivefile-management
0 likes · 3 min read

This article dissects Python’s built‑in set type, explaining how add, pop, remove, copy, update, union and other set operations map to low‑level C functions, how the hash table handles collisions, dummy entries, resizing, and the finger optimization that speeds up element removal.
ADDCOPYHash Table
0 likes · 30 min read

This article introduces Python's built‑in shutil module, explains its key functions for copying, moving, deleting, archiving, and retrieving file information, and provides comprehensive code examples demonstrating how to prepare test files and perform common file‑system tasks such as copying files, moving directories, and creating archives.
COPYMovePython
0 likes · 7 min read

Version 1.7 of Dockerfile introduces enhanced BuildKit capabilities—including #syntax front‑end selection, expanded Bash‑style variable expansions, the --parents flag for preserving directory hierarchies, and --exclude filters—allowing developers to write more flexible, multi‑stage, and platform‑aware container builds with finer control over file copying.
COPYMulti‑stageVariable Expansion
0 likes · 14 min read

Go slices are dynamic, flexible data structures built on arrays, offering automatic growth, efficient memory use, and powerful operations such as creation via make or literals, slicing, appending, copying, iteration, and passing to functions, with detailed examples and visualizations illustrating their internal mechanics.
COPYGoMemory
0 likes · 17 min read

This article explains why a copy button failed on mobile browsers, compares the modern Clipboard API with the deprecated document.execCommand method, and provides a robust fallback implementation in a custom React hook that works across browsers and secure contexts.
COPYClipboardfallback
0 likes · 5 min read

This article explains PHP's copy() function, detailing its syntax, parameters, return values, example usage, and important precautions for safely copying files on the server, including handling of existing destination files, limitations with directories, and cross‑filesystem considerations.
COPYFilesystemPHP
0 likes · 3 min read

This article explains three typical pitfalls of Go slices—ignoring the slice returned by append, unintentionally sharing the underlying array which can cause memory leaks, and the value‑copy behavior of for‑range loops—while also showing how to inspect slice internals using unsafe pointers.
BackendCOPYGo
0 likes · 5 min read

This article explains how to implement a one‑click copy feature in web pages using the modern Clipboard API for text and images, provides compatibility notes, and offers fallback code with document.execCommand('copy') for older browsers and WebViews.
COPYClipboard APIJavaScript
0 likes · 11 min read

When loading massive amounts of data into PostgreSQL, disabling autocommit, postponing index and foreign‑key creation, adjusting memory settings, using COPY or pg_bulkload, and fine‑tuning WAL and trigger settings can dramatically improve import speed and overall performance.
COPYPerformance TuningPostgreSQL
0 likes · 7 min read

This article explains how pandas' copy method works with deep and shallow options, demonstrates their effects on mutable and immutable data, and shows how to safely modify DataFrames using Python's copy module to avoid unintended changes to the original data.
COPYDeep CopyPandas
0 likes · 9 min read

This article provides concise explanations of ten fundamental Python topics, covering differences between lists and tuples, arrays and lists, append versus extend, equality operators, shallow and deep copying, loop control statements, variable scopes, range versus xrange, decorators, and the concepts of iterators and generators.
COPYDecoratorList
0 likes · 7 min read

This article documents a runtime crash triggered by mutating an NSMutableSet while enumerating it, explains how the Objective‑C copy attribute works, demonstrates shallow and deep copy behavior for strings and collections, and provides low‑level source analysis of the copy implementation in the Apple runtime.
COPYDeepCopyMutableSet
0 likes · 14 min read

This article introduces Python’s shutil module, explains its purpose as a shell utility supplement to os, and provides detailed examples of its key functions—including copyfileobj, copy, copy2, copytree, rmtree, move, and make_archive—complete with code snippets and usage tips.
COPYMovearchive
0 likes · 7 min read

This article explains the difference between assignment, shallow copy, and deep copy in Python, shows code examples, visual diagrams, and discusses why shallow copy is the default due to its speed, memory efficiency, and typical use cases.
COPYDeep CopyMemory Management
0 likes · 5 min read

This article explains Python's shallow and deep copy mechanisms, demonstrates their differences with code examples, visual diagrams, and discusses when to use each approach, highlighting performance and memory considerations in software development.
COPYDeep CopyPython
0 likes · 5 min read

This article dives deep into Go's io package, detailing the core Reader and Writer interfaces, their variants like ReaderAt, WriterAt, ReaderFrom, WriterTo, and practical functions such as Copy, CopyBuffer, and Pipe, complete with clear code examples and performance insights.
COPYIOPipe
0 likes · 16 min read

This article explains why copying data in Python is necessary, distinguishes between assignment, shallow copy, and deep copy, demonstrates each with code examples and diagrams, and summarizes the performance and memory trade‑offs of the two copying methods.
COPYDeep CopyShallow Copy
0 likes · 6 min read

This article explains Go slice fundamentals, covering how to create slices with make, the relationship between length and capacity, the behavior of append, why zero values appear, the automatic growth mechanism, and how to safely copy slices using the copy function, illustrated with code examples and diagrams.
COPYGoappend
0 likes · 8 min read

This tutorial walks you through Python's dictionary and set data structures, covering creation, key uniqueness, updating, deleting, copying, and built‑in methods like keys(), while contrasting them with lists and tuples for clear, practical understanding.
COPYPythonTutorial
0 likes · 5 min read

This article explains Java reference copying, object cloning, and the differences between shallow and deep copy, providing code examples and output analysis to illustrate how each method affects object identity and shared references.
COPYDeep CopyJava
0 likes · 8 min read

This article demonstrates how Python functions can receive list arguments, modify them permanently, and how to pass a copy to prevent changes, illustrating the effects with clear code examples and output results.
COPYFunctionList
0 likes · 4 min read

This article explains the internal representation of Go slices, how they are created and initialized, the mechanics of append and capacity growth, slicing behavior, deep‑copy using the copy function, and whether slices are passed by value or reference, all illustrated with source code and assembly excerpts.
COPYGoMemory
0 likes · 24 min read

This article compiles eight representative Python language‑feature questions—covering iterators, generators, decorators, monkey‑patching, identity vs equality, shallow/deep copying, mutability, introspection, and naming conventions—to help candidates ace technical interviews and deepen their core Python knowledge.
COPYIntrospectionNamingConventions
0 likes · 10 min read

This article explains the three MySQL DDL algorithms (COPY, INPLACE, INSTANT), compares third‑party tools like pt‑online‑schema‑change and gh‑ost, and provides practical guidance on selecting algorithms, using ALGORITHM clauses, monitoring progress, and handling performance, space, replication lag, and metadata lock issues.
COPYDDLINPLACE
0 likes · 13 min read

This article explains Python’s magic methods—special double‑underscore functions like __init__, __new__, __getattr__, and __call__—showing how they control object construction, attribute access, custom containers, callability, context management, descriptors, and copying, with clear code examples for each feature.
COPYcallablecontext-manager
0 likes · 15 min read

This article explains the concepts of shallow and deep copying in Objective‑C, detailing how pointers, memory regions, and collection types behave under copy and mutableCopy, introducing three copy levels (CL1‑CL3), and highlighting common pitfalls and best practices for safe memory management.
COPYDeep CopyMemory Management
0 likes · 7 min read
