josephernest

## mklinkgui.py
import win32clipboard    # pip install pywin32 if needed
import sys, os, subprocess
fname = sys.argv[1]
win32clipboard.OpenClipboard()
filenames = win32clipboard.GetClipboardData(win32clipboard.CF_HDROP)
win32clipboard.CloseClipboard()
for filename in filenames:
    base = os.path.basename(filename)
    link = os.path.join(fname, base)
    subprocess.Popen('mklink %s "%s" "%s"' % ('/d' if os.path.isdir(filename) else '', link, filename), shell=True)

## fulltextsearch.py
import sqlite3
db = sqlite3.connect(':memory:')
c = db.cursor()
c.execute('CREATE TABLE mytable (description text)')
c.execute('INSERT INTO mytable VALUES ("Riemann")')
c.execute('INSERT INTO mytable VALUES ("All the Carmichael numbers")')

print '1) EQUALITY'
c.execute('SELECT * FROM mytable WHERE description == "Riemann"'); print 'Riemann:', c.fetchall()

## _pdf_cut_half.py
import os, glob, pdfrw  # todo: pip install pdfrw
for f in glob.glob('*.pdf'):
    if '_cut.pdf' in f:
        continue
    writer = pdfrw.PdfWriter()
    for page in pdfrw.PdfReader(f).pages:
        for y in [0, 0.5]:
            newpage = pdfrw.PageMerge()
            newpage.add(page, viewrect=(0, y, 1, 0.5))
            p = newpage.render()

## index.html
<html>
<head>
<style>
* { margin: 0; }
#topright { float: right; width: 100px; background-color: blue; -webkit-app-region: no-drag; }
#topright:hover { background-color: black; }
#topleft { background-color: red; -webkit-app-region: drag; padding: 10px; }
</style>
</head>
<body>

## duckdbtest.py
"""
Quick benchmark of DuckDB / Sqlite3 (disclaimer: it doesn't necessarily showcase the power of both solutions, there might be better ways I'm not aware of)
https://gist.github.com/josephernest/2c02f7627b83a32fd2086fe9dde15215.js
https://github.com/cwida/duckdb/issues/1249

           1M rows               10M rows                  20M rows                 50M rows
duckdb     13ms   ?              130ms     ?               285ms     ?              ?
sqlite     13ms   26 MB          113ms     260 MB          221ms     527 MB         ?
"""

## get_state.json
{"state": "checked"}

## page2.txt
Hello, now click on the "Back" history button of your browser.
	import win32clipboard # pip install pywin32 if needed
	import sys, os, subprocess
	fname = sys.argv[1]
	win32clipboard.OpenClipboard()
	filenames = win32clipboard.GetClipboardData(win32clipboard.CF_HDROP)
	win32clipboard.CloseClipboard()
	for filename in filenames:
	base = os.path.basename(filename)
	link = os.path.join(fname, base)
	subprocess.Popen('mklink %s "%s" "%s"' % ('/d' if os.path.isdir(filename) else '', link, filename), shell=True)
	import sqlite3
	db = sqlite3.connect(':memory:')
	c = db.cursor()
	c.execute('CREATE TABLE mytable (description text)')
	c.execute('INSERT INTO mytable VALUES ("Riemann")')
	c.execute('INSERT INTO mytable VALUES ("All the Carmichael numbers")')

	print '1) EQUALITY'
	c.execute('SELECT * FROM mytable WHERE description == "Riemann"'); print 'Riemann:', c.fetchall()
	import os, glob, pdfrw # todo: pip install pdfrw
	for f in glob.glob('*.pdf'):
	if '_cut.pdf' in f:
	continue
	writer = pdfrw.PdfWriter()
	for page in pdfrw.PdfReader(f).pages:
	for y in [0, 0.5]:
	newpage = pdfrw.PageMerge()
	newpage.add(page, viewrect=(0, y, 1, 0.5))
	p = newpage.render()
	<html>
	<head>
	<style>
	* { margin: 0; }
	#topright { float: right; width: 100px; background-color: blue; -webkit-app-region: no-drag; }
	#topright:hover { background-color: black; }
	#topleft { background-color: red; -webkit-app-region: drag; padding: 10px; }
	</style>
	</head>
	<body>
	"""
	Quick benchmark of DuckDB / Sqlite3 (disclaimer: it doesn't necessarily showcase the power of both solutions, there might be better ways I'm not aware of)
	https://gist.github.com/josephernest/2c02f7627b83a32fd2086fe9dde15215.js
	https://github.com/cwida/duckdb/issues/1249

	1M rows 10M rows 20M rows 50M rows
	duckdb 13ms ? 130ms ? 285ms ? ?
	sqlite 13ms 26 MB 113ms 260 MB 221ms 527 MB ?
	"""