github.com/rtanglao/rt-r-ggplot2-ruby-experiments/blob/ma...

now with better labelling :-)

used the gglabel package to better place labels

for h in {0..23} do

Rscript ../sqlite-logo-text-hourly-ff-question-barcode.R 2020 10 20 $h done

ls -1 logo-text-hour*.png >2020-10-20-logo-text-hour-filex.txt

magick montage -verbose -adjoin -tile 12x2 +frame +shadow +label -adjoin -geometry "256x256+0+0<" @2020-10-20-logo-text-hour-filex.txt logo-text-20october2020-ff-questions-by-hour.png

Why are you using all my disk - and why is System PID 4 too? Argh! 20150429a.sqlite is 11 GB too

www.reddit.com/r/Windows10/comments/3wlx1v/high_disk_usag... ?

www.flickr.com/help/forum/en-us/72157662400242832/7215766... ?

"QNAP TS-209 Turbo Station is the most powerful 2-bay Network Attached Storage (NAS) product designed for SOHO and Home users. TS-209 adopts the latest powerful 500MHz CPU with 128MB DDR II RAM and Gigabit Ethernet design; its ultra-high-speed performance significantly boosts the file sharing speed. Abundant valuable server features are also included, such as advanced auto-sync/schedule/instant backup, cross-platform sharing for Windows and Mac, Web Server of PHP with MySQL and SQLite, RAID 1 mirroring protection with hot-swapping design, encrypted FTP file sharing, encrypted Remote Replication, unique Web File Manager, built-in DDNS, SSL and SSH remote login, etc.. These differentiated designs make TS-209 a perfect choice for SOHO users who need faster performance and useful server features. With its friendly web-based interface, users can easily set up a network system for all sorts of server applications without MIS help.

TS-209 is also designed for home users. You can easily build up a perfect multimedia storage center for backing up and sharing multimedia files with your friends and family. TS-209 provides a lot of attractive server functions, such as iTunes Server, UPnP/ DLNA Media Server (TwonkyMedia) with Internet Radio, Multimedia Station with web-based photo album, BitTorrent Download Station, etc..

With the smart fan and excellent mechanical design by hard disk drive bracket to make wind tunnel effect, TS-209 is with the best heat dissipation. TS-209 can run 24x7, 365 days for all applications and keep hard disk drive temperature under 50°C. Supporting two 3.5” SATA drives up to 2TB large storage capacity, QNAP TS-209 Turbo Station is no doubt a smart choice for SOHO and home users."

see github.com/rtanglao/rt-flickr-sqlite-csv/blob/main/README...

In Firefox profile folder, in this case ~/.mozilla/firefox/xq9kcegy.default, places.sqlite keeps all bookmarks and browsing history.

I just found I have 43XXX records in moz_places table, 13XX in moz_inputhistory. It seems that I need to slim it.

Try the sqlite manager addon for Firefox, it rocks.

I set keep history to 90 days in my case.

Use sqlite3 places.sqlite 'VACUUM'; to shrink the sqlite database file. You can see the performance improvements.

Firefox profile目录下places.sqlite保存着书签和所有浏览记录。

moz_places 43XXX

moz_inputhistory 13XX

Record已经很多了，我设置了保存90天的浏览历史，看来找时间要清理一下了。第一次启动，匹配已经有些慢了。

用sqlite3 places.sqlite 'VACUUM'; 命令清理places.sqlite数据库对提升地址栏的性能有一定帮助。

kb.mozillazine.org/Locked_or_damaged_places.sqlite

"QNAP TS-109 Pro Turbo Station is an ultra-high-speed All-in-one NAS (Network Attached Storage) server designed for SMB/SOHO and professional users. With the easy installation, friendly web-based interface, and complete server feature sets, small office users can easily set up a network system for all sorts of storage applications without MIS help.

TS-109 Pro supports many valuable functions like File Server, FTP Server, Printer Server, etc. to satisfy the needs of SMB and SOHO users. Meanwhile, Windows ADS (Active Directory Service) is supported to help create an easy–to-access environment and lower the maintenance cost by centralized management. With the dual support of MySQL and SQLite, SMB/ SOHO users can easily set up their own web and database server. Moreover, the editable php.ini support enables higher flexibility in creating web pages.

TS-109 Pro provides the most complete backup solution for secure data protection: Remote Replication, Auto-Sync/ Instant/ Schedule backup by professional NetBak Replicator, and unique Q-RAID 1 mirroring for real-time data protection.

QNAP TS-109 Pro Turbo Station supports large capacity SATA disk of up to 1TB and is extendable to 2TB by ultra-fast eSATA and USB 2.0 port. With its noise-free design and outstanding heat dissipation technology, TS-109 Pro can run 24x7 silently at low power consumption of only 14.4W. It is ideal choice for small business looking for a quiet and power-saving storage application."

(with indexing bug fixed)

for h in {0..23} do

Rscript ../sqlite-logo-text-hourly-ff-question-barcode.R 2020 10 20 $h done

ls -1 logo-text-hour*.png >2020-10-20-logo-text-hour-filex.txt

magick montage -verbose -adjoin -tile 12x2 +frame +shadow +label -adjoin -geometry "256x256+0+0<" @2020-10-20-logo-text-hour-filex.txt logo-text-20october2020-ff-questions-by-hour.png

從2008/12/26到現在，共包含40596個項目

Lighttpd + PHP on iPhone

Wearable Agency - app development company #USA #UK #United States #Canada #India #France #Belarus #Malaysia #Russia #Moldova #Tunisia #SouthAfrica #Ukraine #UnitedKingdom #Bulgaria #Poland #PAKISTAN #TAILAND #mobile #digital #development #iphone #ipad #ios #android #NewYork #sanfrancisco #Texas #Canada #Digital #wearables

414.7MB

Root Explorer is the ultimate file manager for root users. Access the whole of android's file system (including the elusive data folder!)

Features include multiple tabs, Google Drive, Box, Dropbox and network (SMB) support, SQLite database viewer, Text Editor, create and extract zip or tar/gzip files, extract rar archives, multi-select, execute scripts, search, remount, permissions, bookmarks, send files (via email, bluetooth etc), image thumbnails, APK binary XML viewer, change file owner/group, create symbolic link, "Open With" facility, MD5, create shortcuts.

@ Google play (3,48 €) :

play.google.com/store/apps/details?id=com.speedsoftware.r...

#RootExplorer

Artifex Terra 3D is a brushcentric and easy to use WYSIWYG-style terrain

and outdoor scene editor with support for splatting, colour-painting, dynamic lighting, grass & object editing,

infinite custom value pairs per object, custom SQLite based scene-loader as well as a scripted dotScene

converter. www.artifexterra3d.com/

Artifex Terra 3D is a brushcentric and easy to use WYSIWYG-style terrain

and outdoor scene editor with support for splatting, colour-painting, dynamic lighting, grass & object editing,

infinite custom value pairs per object, custom SQLite based scene-loader as well as a scripted dotScene

converter. www.artifexterra3d.com/

Tonight's project: sqail

"tail -f" for SQLite database tables.

Source code: pastebin.com/f618be509

Alejandro Ramos

"Te pique lo que te pique, analiza un SQLite"

Discussed at surfmind.com/muzings/?p=120

mostly accurate colophon :-) github.com/rtanglao/rt-flickr-sqlite-csv/blob/main/no-cap...

colophon: github.com/rtanglao/rt-flickr-sqlite-csv/blob/main/README...

Artifex Terra 3D is a brushcentric and easy to use WYSIWYG-style terrain

and outdoor scene editor with support for splatting, colour-painting, dynamic lighting, grass & object editing,

infinite custom value pairs per object, custom SQLite based scene-loader as well as a scripted dotScene

converter. www.artifexterra3d.com/

This demo uses the RFID and the SQLite in the device

for h in {0..23} do

Rscript ../sqlite-text-hourly-ff-question-barcode.R 2020 10 20 $h done

ls -1 text-hour*.png >2020-10-20-text-hour-filex.txt

magick montage -verbose -adjoin -tile 12x2 +frame +shadow +label -adjoin -geometry "256x256+0+0<" @2020-10-20-text-hour-filex.txt text-20october2020-ff-questions-by-hour.png

github.com/rtanglao/rt-flickr-sqlite-csv/blob/main/README... <-- colophon

bash commands:

magick convert right-leg_artofwhere-red-pink-2019-20.png -transparent "#ffffff" transparent-right-leg_artofwhere-red-pink-2019-20.png

magick convert left-leg_artofwhere-red-pink-2019-20.png -transparent "#ffffff" transparent-left-leg_artofwhere-red-pink-2019-20.png

magick convert -background none -layers flatten transparent-right-leg_artofwhere-red-pink-2019-20.png transparent-left-leg_artofwhere-red-pink-2019-20.png transparent-artofwhere_left_and_right_overlaid-red-pink-2019-2020.png # [1]

# drawing over makes the same image as [1]

magick transparent-right-leg_artofwhere-red-pink-2019-20.png -draw "image over 0,0 0,0 'transparent-left-leg_artofwhere-red-pink-2019-20.png'" drawover-transparent-artofwhere_left_and_right_overlaid-red-pink-2019-2020.png

(with indexing bug fixed)

for h in {0..23} do

Rscript ../sqlite-text-hourly-ff-question-barcode.R 2020 10 20 $h done

ls -1 text-hour*.png >2020-10-20-text-hour-filex.txt

magick montage -verbose -adjoin -tile 12x2 +frame +shadow +label -adjoin -geometry "256x256+0+0<" @2020-10-20-text-hour-filex.txt text-20october2020-ff-questions-by-hour.png

This gives TileMill cartographers an alternative geographic data source to shapefiles and the ability to join multiple databases from different sources together into one source.

For more details, see Will's blog post:

You can download TileMill here.

Artifex Terra 3D is a brushcentric and easy to use WYSIWYG-style terrain

and outdoor scene editor with support for splatting, colour-painting, dynamic lighting, grass & object editing,

infinite custom value pairs per object, custom SQLite based scene-loader as well as a scripted dotScene

converter. www.artifexterra3d.com/

On demand loading of network nodes in range. Application uses GRDB for accessing SQLite database. The database itself uses an r-tree spatial index. Monitoring regions to be added.

Application is simulating 135860 kollum-anjum-en-zoutkamp bicycle route.

dashmark is conceptual book mark application featuring brand new web browser Safari 3.1.

dashmark demonstrate how Safari 3.1's new function named "CSS Animation" and "Client-side database storage" make our web experience better. dashmark store bookmark information on SQLite.

dashmark : t_trace.wed.macserver.jp/comments.html

release note : d.hatena.ne.jp/t_trace/20080409/1207763828

Alejandro Ramos

"Te pique lo que te pique, analiza un SQLite"

Mike (on your left) is author of the book "The Definitive Guide to SQLite" and Richard is, well, the author of SQLite.

colophon: github.com/rtanglao/rt-flickr-sqlite-csv/blob/main/README...

Just Google sqlite and there shows extra links under the first result.

The next big google thing is ... the ultimate frontend of web pages ?

Alejandro Ramos

"Te pique lo que te pique, analiza un SQLite"

Artifex Terra 3D is a brushcentric and easy to use WYSIWYG-style terrain

and outdoor scene editor with support for splatting, colour-painting, dynamic lighting, grass & object editing,

infinite custom value pairs per object, custom SQLite based scene-loader as well as a scripted dotScene

converter. www.artifexterra3d.com/

Session Extraction in Firefox3 History, more at surfmind.com/muzings/?p=120

Artifex Terra 3D is a brushcentric and easy to use WYSIWYG-style terrain

and outdoor scene editor with support for splatting, colour-painting, dynamic lighting, grass & object editing,

infinite custom value pairs per object, custom SQLite based scene-loader as well as a scripted dotScene

converter. www.artifexterra3d.com/

Playing with SQLite.

pastebin.com/f16a92ba9

For fun: You can see that I use my fixed 50mm and 21mm lenses far more than anything else I've got.

I use Adobe's Lightroom to manage my RAW photos. It's a wonderful, splendid tool. It provides a handy metadata browser of your photo library, and includes the ability to browse by lens. Recently James Duncan Davidson mentioned being interested in plotting his use of various focal lengths, and commenters responded with a number of solutions. Since Lightroom uses a SQLite database for its library, tools like SQLite Browser can be used to scan through the database file itself. This is pretty slick all by itself, but I thought I'd put together a quick tool to automate the extraction and generation of this data. To do that, I use sqlite3 from the command line to dump the metadata table to a file, and then a short bit of R code finds the focal lengths and builds the histogram.

I wrote up some additional details over at my lacking-content-lately blog.

Artifex Terra 3D is a brushcentric and easy to use WYSIWYG-style terrain

and outdoor scene editor with support for splatting, colour-painting, dynamic lighting, grass & object editing,

infinite custom value pairs per object, custom SQLite based scene-loader as well as a scripted dotScene

converter. www.artifexterra3d.com/