softMaina softMaina

## compress-pdf-with-gs.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                softMaina
                / compress-pdf-with-gs.md
            
            
              Created
              April 1, 2021 08:45
                — forked from guifromrio/compress-pdf-with-gs.md
            
              
                Compress PDF files with ghostscript
              
          
    This can reduce files to ~15% of their size (2.3M to 345K, in one case) with no obvious degradation of quality.
ghostscript -sDEVICE=pdfwrite -dCompatibilityLevel=1.4 -dPDFSETTINGS=/printer -dNOPAUSE -dQUIET -dBATCH -sOutputFile=output.pdf input.pdf

Other options for PDFSETTINGS:

/screen selects low-resolution output similar to the Acrobat Distiller "Screen Optimized" setting.
/ebook selects medium-resolution output similar to the Acrobat Distiller "eBook" setting.
/printer selects output similar to the Acrobat Distiller "Print Optimized" setting.
/prepress selects output similar to Acrobat Distiller "Prepress Optimized" setting.


## query.sql
select * from table t1
where (select count(*) from table t2
where t1.field = t2.field) > 1
order by field

## onlinenowMiddelware.py
from django.conf import settings
from django.core.cache import cache
from django.contrib.auth.models import User
from django.utils.deprecation import MiddlewareMixin

ONLINE_THRESHOLD = getattr(settings, 'ONLINE_THRESHOLD', 60 * 15)
ONLINE_MAX = getattr(settings, 'ONLINE_MAX', 50)

def get_online_now(self):
    return User.objects.filter(id__in=self.online_now_ids or [])
	select * from table t1
	where (select count(*) from table t2
	where t1.field = t2.field) > 1
	order by field
	from django.conf import settings
	from django.core.cache import cache
	from django.contrib.auth.models import User
	from django.utils.deprecation import MiddlewareMixin

	ONLINE_THRESHOLD = getattr(settings, 'ONLINE_THRESHOLD', 60 * 15)
	ONLINE_MAX = getattr(settings, 'ONLINE_MAX', 50)

	def get_online_now(self):
	return User.objects.filter(id__in=self.online_now_ids or [])