4259 links
  • Arnaud's links
  • Home
  • RSS Feed
  • Tag cloud
  • Login
search: tag:sqlite — newest first
  • Command Line Shell For SQLite

    .mode line

    Quand meme bien plus lisible que le mode par défaut pour afficher 1 entrée

    In "line" mode, each column in a row of the database is shown on a line by itself. Each line consists of the column name, an equal sign and the column data. Successive records are separated by a blank line. Here is an example of line mode output:

    sqlite> .mode line
    sqlite> select * from tbl1;
    one = hello
    two = 10
    
    one = goodbye
    two = 20
    sqlite>
    

    sqlite> .mode line

    May 28, 2015 - permalink - https://www.sqlite.org/cli.html
    display sqlite
  • DB Browser for SQLite

    via nicolasc

    May 13, 2015 - permalink - http://sqlitebrowser.org/
    browser sqlite
  • SQLiteJDBC Usage
    June 7, 2012 - permalink - http://www.zentus.com/sqlitejdbc/usage.html
    sqlite
  • Code sample: Using transactions - Data Storage - Development Guide - BlackBerry Java SDK - 6.0
    June 7, 2012 - permalink - http://docs.blackberry.com/en/developers/deliverables/17952/CS_using_SQLite_transactions_1222423_11.jsp
    bukkit games sqlite transaction
  • new plugin

    requete top mineur tout minerai confondu :
    SELECT player,COUNT(*) AS total FROM block GROUP BY player ORDER BY total DESC

    requete top mineur d'un block en particulier :
    SELECT player,COUNT(*) AS total FROM block WHERE id='15' GROUP BY player ORDER BY total DESC

    June 7, 2012 - permalink - https://links.infomee.fr/shaare/0htx0w
    bukkit ewok games sqlite
  • Insert multiple en SQLite

    insert into block (player, id)
    select 'meka','15'
    union
    select 'blou','18'
    union
    select 'blou','15'
    union
    select 'blou','16'
    union
    select 'blou','15'
    union
    select 'meka','15'
    union
    select 'meka','16'

    June 7, 2012 - permalink - https://links.infomee.fr/shaare/2aWaDw
    bukkit games sqlite
  • SQLITE + MINECRAFT

    Pour faire des requetes tout ça :
    http://forums.bukkit.org/threads/lib-tut-mysql-sqlite-bukkit-drivers.33849/
    http://java.developpez.com/faq/jdbc/?page=resultset#valeursRS
    http://java.developpez.com/faq/jdbc/?page=metadataresultset

    June 4, 2012 - permalink - https://links.infomee.fr/shaare/U1odcw
    bukkit games minecraft sqlite
  • La FAQ JDBC
    June 4, 2012 - permalink - http://java.developpez.com/faq/jdbc/?page=resultset#valeursRS
    sqlite