Saturday, February 15, 2025
HomeApplemacos - Getting truncated content material from Apple Notes SQLite DB

macos – Getting truncated content material from Apple Notes SQLite DB


If you happen to run this question in your Mac OS, it prints newest notice from Notes app. The difficulty that there’s extra content material, it will get truncated. I’ve numbers from 1 to 300, however only one to 82 are returned. What’s the challenge? How you can print full content material?

Thanks

% cd "$HOME/Library/Group Containers/group.com.apple.notes" && 
sqlite3 NoteStore.sqlite "SELECT * FROM ZICCLOUDSYNCINGOBJECT ORDER BY Z_PK DESC LIMIT 1"
4882|11|12|0|0|0|0|0|0|||4874|||||||||||||||||||||||||||||||||||||||0|0|0|0|0|||0||4|3|2593||||||||||||||||||||||||||||||||||||||||||758832855.156849|758832855.158181|758228055.158249|758228055.158249|758832855.158247||758834369.024801|-541228980||758835621.195935|||||2D21D111-B939-430E-95BC-55BA145654E6||||||||||||||||||||||||||||||||||1||notes-length-test|notes-length-test
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82||||||||||||||||||||

||||||||||||||||||||||||||
%

Note

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments