Portada

Este es el blog del buscador temático sobre el open source Via Alternativa, basado en la API de Google.

En este espacio encontrarás noticias de varias fuentes RSS relacionadas con el mundo del código abierto y comunidades gnu-linux.

Todo el contenido de las anotaciones es responsabilidad de aquellos que las escriben y sus respectivas webs. Si administras una web enlazada por RSS y no estás de acuerdo con la redistribución de tus contenidos contacta con nosotros.

¡A divertirse!

Nuestra generación no se habrá lamentado tanto de los crimenes de los perversos, como del estremecedor silencio de los bondadosos

— Martin Luther King

Logo Via Alternativa

Entradas recientes

SQLite Extraction of Oracle Tables Tools, Methods and Pitfalls

sqlite

Introduction

The SQLite database is a wildly successful and ubiquitous software package that is mostly unknown to the larger IT community. Designed and coded by Dr. Richard Hipp, the third major revision of SQLite serves many users in market segments with critical requirements for software quality, which SQLite has met with compliance to the DO-178B avionics standard. In addition to a strong presence in aerospace and automotive, most major operating system vendors (including Oracle, Microsoft, Apple, Google, and RedHat) include SQLite as a core OS component.

There are a few eccentricities that may trip up users from other RDBMS environments. SQLite is known as a “flexibly-typed” database, unlike Oracle which rigidly enforces columnar datatypes; character values can be inserted into SQLite columns that are declared integer without error (although check constraints can strengthen SQLite type rigidity, if desired). While many concurrent processes are allowed to read from a SQLite database, only one process is allowed write privilege at any time (applications requiring concurrent writers should tread carefully with SQLite). There is no network interface, and all connections are made through a filesystem; SQLite does not implement a client-server model. There is no “point in time recovery,” and backup operations are basically an Oracle 7-style ALTER DATAFILE BEGIN BACKUP that makes a transaction-consistent copy of the whole database. GRANT and REVOKE are not implemented in SQLite, which uses filesystem permissions for all access control. There are no background processes, and newly-connecting clients may find themselves delayed and responsible for transaction recovery, statistics collection, or other administrative functions that are quietly performed in the background in this “zero-administration database.” Some history and architecture of SQLite can be found in audio and video records of Dr. Hipp's discussions.

  1. Vulnerability Detection and Patching: A Survey Of The Enterprise Environment Comentarios desactivados en Vulnerability Detection and Patching: A Survey Of The Enterprise Environment
  2. Live Patching Requires Reproducible Builds – and Containers Are the Answer Comentarios desactivados en Live Patching Requires Reproducible Builds – and Containers Are the Answer
  3. An Abridged Guide to the Enterprise Linux Landscape Comentarios desactivados en An Abridged Guide to the Enterprise Linux Landscape
  4. Systemd Service Strengthening Comentarios desactivados en Systemd Service Strengthening
  5. eBPF for Advanced Linux Infrastructure Monitoring Comentarios desactivados en eBPF for Advanced Linux Infrastructure Monitoring
  6. How to set up a CrowdSec multi-server installation Comentarios desactivados en How to set up a CrowdSec multi-server installation
  7. Develop a Linux command-line Tool to Track and Plot Covid-19 Stats Comentarios desactivados en Develop a Linux command-line Tool to Track and Plot Covid-19 Stats
  8. FSF’s LibrePlanet 2021 Free Software Conference Is This Weekend, Online Only Comentarios desactivados en FSF’s LibrePlanet 2021 Free Software Conference Is This Weekend, Online Only
  9. Review: The New weLees Visual LVM, a new style of LVM management, has been released Comentarios desactivados en Review: The New weLees Visual LVM, a new style of LVM management, has been released
  10. Nvidia Linux drivers causing random hard crashes and now a major security risk still not fixed after 5+ months Comentarios desactivados en Nvidia Linux drivers causing random hard crashes and now a major security risk still not fixed after 5+ months
  11. Parallel shells with xargs: Utilize all your cpu cores on UNIX and Windows Comentarios desactivados en Parallel shells with xargs: Utilize all your cpu cores on UNIX and Windows
  12. Bypassing Deep Packet Inspection: Tunneling Traffic Over TLS VPN Comentarios desactivados en Bypassing Deep Packet Inspection: Tunneling Traffic Over TLS VPN
  13. How to Save Time Running Automated Tests with Parallel CI Machines Comentarios desactivados en How to Save Time Running Automated Tests with Parallel CI Machines
  14. The KISS Web Development Framework Comentarios desactivados en The KISS Web Development Framework
  15. Linux in Healthcare – Cutting Costs & Adding Safety Comentarios desactivados en Linux in Healthcare – Cutting Costs & Adding Safety
  16. MuseScore Created New Font in Memory of Original SCORE Program Creator Comentarios desactivados en MuseScore Created New Font in Memory of Original SCORE Program Creator
  17. MuseScore Created New Font in Memory of Original SCORE Program Creator Comentarios desactivados en MuseScore Created New Font in Memory of Original SCORE Program Creator
  18. Virtual Machine Startup Shells Closes the Digital Divide One Cloud Computer at a Time Comentarios desactivados en Virtual Machine Startup Shells Closes the Digital Divide One Cloud Computer at a Time
  19. An Introduction to Linux Gaming thanks to ProtonDB Comentarios desactivados en An Introduction to Linux Gaming thanks to ProtonDB