Coder Social home page Coder Social logo

info-database's Introduction

Info-database

Python script to obtain data from a database (SQLITE)

How are the number of tables, number of columns, rows and data in each table, and the number of total records

Write the name of the database and get some of its data

Script de Python para obtener los datos de una base de datos (SQLITE)

Como son el numero de tablas, numero de columna, filas y datos de cada tabla, y el numero de registros totales

Escribe el nombre de la base de datos y obten algunos de sus datos

EXAMPLE

The database has 12 tables

The tables android_metadata has 1 columns, 1 rows and 1 registers

The tables sport_summary has 8 columns, 205 rows and 1640 registers

The tables location_data has 13 columns, 177949 rows and 2313337 registers

The tables running_info_per_km has 11 columns, 1276 rows and 14036 registers

The tables heart_rate has 14 columns, 797587 rows and 11166218 registers

The tables request has 4 columns, 4 rows and 16 registers

The tables medal has 2 columns, 0 rows and 0 registers

The tables running_info_per_lap has 23 columns, 907 rows and 20861 registers

The tables cadence_detail has 7 columns, 0 rows and 0 registers

The tables sport_tha_info has 16 columns, 732 rows and 11712 registers

The tables daily_perpormance_info has 6 columns, 1999 rows and 11994 registers

The tables vo2_max_day_info has 5 columns, 172 rows and 860 registers

The database sport_data.db has 13540675 dates

info-database's People

Contributors

javitum avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.