Manuel Holtgrewe holtgrewe

## interesting_crates.md

      
              1 file
            
          
              3 forks
            
          
              0 comments
            
          
              23 stars
            
          
                vi
                / interesting_crates.md
            
            
              Last active
              April 27, 2024 22:00
            
              
                List of crates that improves or experiments with Rust, but may be hard to find
              
          
    Let's list here crates that enhance Rust as a language.
It not "batteries" like in stdx, but Rust-specific crates for workarounds for various missing features and experimental ideals from non-accepted/postponed RFCs, or just hacky tricks.
The list is supposed to contain (mostly) crates that are internal to Rust, not ones for making Rust deal with "external world" like other languages bindings, file formats, protocols and so on.
Primary focus should be on crates that are not easy to find by conventional means (e.g. no algorithm name, format or protocol to search for).
Note that quality of the listed crates may vary from proof-of-concept to stable-and-widely-used.

  
## README.md

      
              1 file
            
          
              25 forks
            
          
              6 comments
            
          
              155 stars
            
          
                valyala
                / README.md
            
            
              Last active
              June 3, 2024 17:00
            
              
                Optimizing postgresql table for more than 100K inserts per second
              
          
    Optimizing postgresql table for more than 100K inserts per second


Create UNLOGGED table. This reduces the amount of data written to persistent storage by up to 2x.
Set WITH (autovacuum_enabled=false) on the table. This saves CPU time and IO bandwidth
on useless vacuuming of the table (since we never DELETE or UPDATE the table).
Insert rows with COPY FROM STDIN. This is the fastest possible approach to insert rows into table.
Minimize the number of indexes in the table, since they slow down inserts. Usually an index
on time timestamp with time zone is enough.
Add synchronous_commit = off to postgresql.conf.
Use table inheritance for fast removal of old data:


## timelapse.md

      
              1 file
            
          
              11 forks
            
          
              4 comments
            
          
              69 stars
            
          
                porjo
                / timelapse.md
            
            
              Last active
              May 25, 2023 16:14
            
              
                ffmpeg time-lapse
              
          
    Convert sequence of JPEG images to MP4 video

Simple glob:
ffmpeg -r 24 -i '*.JPG' -s hd1080 -vcodec libx264 timelapse.mp4

Start from DSC_0079.JPG
ffmpeg -r 24 -f image2 -start_number 79 -i DSC_%04d.JPG -s hd1080 -vcodec libx264 timelapse2.mp4