Recherche avancée

Sur d’autres sites (11973)

• Anomalie #4374 : Sauvegarde au format SQLite impossible avec les dernières version de MariaDB

  7 novembre 2020, par b b

  Un truc comme ça @marcimat ?

  <span class="CodeRay"><span class="line comment">diff --git a/ecrire/req/sqlite_generique.php b/ecrire/req/sqlite_generique.php</span>
  <span class="line comment">index 8ed38dc0a5..00d61660ee 100644</span>
  <span class="line head"><span class="head">--- </span><span class="filename">a/ecrire/req/sqlite_generique.php</span></span>
  <span class="line head"><span class="head">+++ </span><span class="filename">b/ecrire/req/sqlite_generique.php</span></span>
  <span class="change"><span class="change">@@</span> -2429,6 +2429,7 <span class="change">@@</span></span> <span class="keyword">function</span> <span class="function">_sqlite_remplacements_definitions_table</span>(<span class="local-variable">$query</span>, <span class="local-variable">$autoinc</span> = <span class="predefined-constant">false</span>) {
           <span class="string"><span class="delimiter">'</span><span class="content">/((char|varchar)</span><span class="delimiter">'</span></span> . <span class="local-variable">$num</span> . <span class="string"><span class="delimiter">'</span><span class="content">\s</span><span class="content">+not</span><span class="content">\s</span><span class="content">+null(</span><span class="content">\s</span><span class="content">+collate</span><span class="content">\s</span><span class="content">+</span><span class="content">\w</span><span class="content">+)?)</span><span class="content">\s</span><span class="content">*$/is</span><span class="delimiter">'</span></span> => <span class="string"><span class="delimiter">"</span><span class="char">\\</span><span class="content">1 DEFAULT ''</span><span class="delimiter">"</span></span>,
           <span class="string"><span class="delimiter">'</span><span class="content">/(datetime</span><span class="content">\s</span><span class="content">+not</span><span class="content">\s</span><span class="content">+null)</span><span class="content">\s</span><span class="content">*$/is</span><span class="delimiter">'</span></span> => <span class="string"><span class="delimiter">"</span><span class="char">\\</span><span class="content">1 DEFAULT '0000-00-00 00:00:00'</span><span class="delimiter">"</span></span>,
           <span class="string"><span class="delimiter">'</span><span class="content">/(date</span><span class="content">\s</span><span class="content">+not</span><span class="content">\s</span><span class="content">+null)</span><span class="content">\s</span><span class="content">*$/is</span><span class="delimiter">'</span></span> => <span class="string"><span class="delimiter">"</span><span class="char">\\</span><span class="content">1 DEFAULT '0000-00-00'</span><span class="delimiter">"</span></span>,
  <span class="line insert"><span class="insert">+</span>        <span class="string"><span class="delimiter">'</span><span class="content">/current_timestamp</span><span class="content">\(</span><span class="content">\)</span><span class="content">/</span><span class="delimiter">'</span></span> => <span class="string"><span class="delimiter">'</span><span class="content">CURRENT_TIMESTAMP</span><span class="delimiter">'</span></span></span>
       );
   
       <span class="comment">// pour l'autoincrement, il faut des INTEGER NOT NULL PRIMARY KEY</span>
   
  </span>
  Télécharger

• Transparent movie with video format qtrle unplayable in QuickTime

  1er janvier 2021, par 220284

  I use the python library Manim to generate mathematical animations. I want to use the animations in Keynote presentations. Manim has the option to produce movie clips with a transparent background. Unfortunately, QuickTime won't play the files generated by Manim. Here's the metadata for a file produced by Manim

  


  Metadata:
    major_brand     : qt  
    minor_version   : 512
    compatible_brands: qt  
    encoder         : Lavf58.45.100
  Duration: 00:01:07.00, start: 0.000000, bitrate: 6635 kb/s
    Stream #0:0: Video: qtrle (rle  / 0x20656C72), argb(progressive), 1280x960, 6632 kb/s, 60 fps, 60 tbr, 15360 tbn, 15360 tbc (default)
    Metadata:
      handler_name    : VideoHandler
      encoder         : Lavc58.91.100 qtrle


  


  Ideally, I would want to use ffmpeg to turn these files into movie clips with transparent background which are playable in QuickTime. Can this be done ?

  


  As a work around, I imported the files into Final Cut Pro and exported them again using Apple Pro Res 4444, but this resulted in huge file sizes.

  


• What format/protocol does ffmpeg use for "raw" output ?

  9 janvier 2021, par MSalters

  Given a commandline ffmpeg -f lavfi -i "sine=frequency=1000:duration=5" -ar 8000 -c:a FOO pipe:1, ffmpeg might complain it's "unable to find a suitable output format". For some codecs, ffmpeg has a default container format, e.g. -c:a libmp3lame will produce MP3's. For other codecs, you just repeat yourself (sort of) : -c:a pcm_alaw -f alaw

  



  But what if I want to stream the raw codec output, and there's no matching -f ? Can I just take -f alaw and assume that it doesn't do anything ? (G711 alaw is a simple codec which produces a byte stream, so -f alaw presumably just copies that byte stream)

  



  Obviously the other side of the pipe needs to know how the data stream needs to be interpreted, if there's no container info. But assume that I already know the other side of the pipe is expecting an audio stream, sampled at 8 kHz, encoded with -c:a FOO.