How Samba and SMB Versions Relate

SMB/CIFS is a protocol made by Microsoft for sharing files across the network. Samba is a set of tools/libraries created to provide support for SMB/CIFS in Linux and Mac.

SMB VersionReleased inSambaLinux
SMB1DOSSamba 1.x
SMB2.0Vista
2008
Samba 3.6
SMB2.1Win7
2008R2
Samba 4.0.0Linux 3.7
SMB3 (SMB2.2)Win8
2012
Samba 4.1
SMB3.0.2 (SMB3.02)Win8.1
2012R2
Linux 3.12 (backported)
SMB3.1.1Win10
2016
Samba 4.3Linux 4.2

Hopefully nobody is still using SMB1 still, it is insecure and obsolete. Indeed from Samba 4.11 and Linux 6 onwards, disable it by default.

Merging SQLite Databases

If you have two SQLite databases which are the same tables, you can merge them by attaching and then inserting.

$ sqlite3 data.sqlite3
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> attach 'data2.sqlite3' as merge;
sqlite> .table
archive        merge.archive
sqlite> begin;
sqlite> insert into archive select * from merge.archive;
sqlite> commit;
sqlite> detach merge;
sqlite> .quit

It is also just a useful way to handle multiple databases in a single session.