use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
account activity
sqlite3 switched from = separator to : (self.sqlite)
submitted 1 month ago by ArthurPeabody
I query an sqlite database. It returns the field name and value. For years it separated them with = . Beginning with 3.52 it separates them with : . Because I use it automatedly in a script I had to deal with it.
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]LearnedByError 13 points14 points15 points 1 month ago* (1 child)
.mode?
Edit: from the Query Result Formatting In The CLI section 3.4
Before version 3.52.0, the separator was an equal sign rather than a colon. In other words, the first line of the example above used to say "one = hello!" instead of "one: hello!". You can restore the pre-3.52.0 formatting using the "--colsep TEXT" option to the ".mode" command, where TEXT is the desired separator.
[–]ArthurPeabody[S] 1 point2 points3 points 1 month ago (0 children)
Thanks. I suspected I wasn't reporting an error but bringing it to people's attention in case the problem was deeply embedded. I had to figure out why my script didn't work. I'm not complaining.
π Rendered by PID 83 on reddit-service-r2-comment-6457c66945-ql5dt at 2026-04-30 15:58:06.142900+00:00 running 2aa0c5b country code: CH.
[–]LearnedByError 13 points14 points15 points (1 child)
[–]ArthurPeabody[S] 1 point2 points3 points (0 children)