none
Database Manager RRS feed

  • General discussion

  • This thread is about Database Manger. It is developed in Small Basic and uses the Litdev extension and lets you make , create , edit , import , and export sqlite databases . 

    Below is a screenshot of the UI:

    It is hosted on Google Driver so click here to view.

    Any feedback would be appreciated.

    v1106 is now live. Changes include:

    Can now export into .csv , .sql , and .xml file formats. 

    'Changing of Online EULA Path

    • Edited by a65001 Saturday, April 23, 2016 9:03 PM
    Friday, April 22, 2016 1:41 AM

All replies

  • Nice interface. Love SQLite.
    Friday, April 22, 2016 3:09 PM
    Moderator
  • Nice interface. Love SQLite.
    Thanks , I do love SQLite myself. Such a useful tool . You see any features that you want to see in future releases ? 
    Friday, April 22, 2016 11:59 PM
  • Sounds great, i mean some of the albums and the same Cobham (1979, drum sticks in casket, because of Stratus) was my very first vinyl together with D. Passport - Ataraxia (1978). ♥♫♪♫♪♫★✿☺♥.

    About DatabaseManager, had'nt time to try until yet, but looks nice at first sight.

    Saturday, April 23, 2016 8:32 PM
    Answerer
  • Just wanted to update this in case anybody stumbles upon this post in the future . 

    I have 11 new minor revisions and the program is now at version v1117 at time of posting alongside with it now being hosted at Github . If the program throws any errors deleting the settings file in the Assets folder should solve 99% of issues related to starting up the program.

    Friday, October 14, 2016 8:19 PM
  • Hi A65001 !

    i went to github ( your link ) but there is no way to download the program and try it ?

    Do you the program number : ?

    so i can download with the small basic import feature,

    Saturday, October 15, 2016 5:18 PM
    Answerer
  • Hi Yled ,

    Here is a direct download link

    For future reference ,on most Github pages the download button is the green button which says : "Clone or Download" . For your purposes you would click the download zip button or use the direct download link provided above.
    If you want some sample data to play around with you can use the chinookdatabase sample or the following extracted from Litdev Sample :

    BEGIN TRANSACTION;
    DROP TABLE IF EXISTS Cars;
    CREATE TABLE Cars(Id INTEGER PRIMARY KEY, Name TEXT, Cost NUM);
    INSERT INTO Cars(Name,Cost)VALUES('Audi','52642');
    INSERT INTO Cars(Name,Cost)VALUES('Mercedes','57127');
    INSERT INTO Cars(Name,Cost)VALUES('Skoda','9000');
    INSERT INTO Cars(Name,Cost)VALUES('Volvo','29000');
    INSERT INTO Cars(Name,Cost)VALUES('Bentley','350000');
    INSERT INTO Cars(Name,Cost)VALUES('Citroen','21000');
    INSERT INTO Cars(Name,Cost)VALUES('Hummer','41400');
    INSERT INTO Cars(Name,Cost)VALUES('Volkswagen','21600');
    COMMIT;
    
    BEGIN TRANSACTION;
    DROP TABLE IF EXISTS Orders;
    CREATE TABLE Orders(Id INTEGER PRIMARY KEY, OrderPrice NUM, Customer TEXT);
    INSERT INTO Orders(OrderPrice,Customer)VALUES('1200','Williamson');
    INSERT INTO Orders(OrderPrice,Customer)VALUES('200','Robertson');
    INSERT INTO Orders(OrderPrice,Customer)VALUES('40','Robertson');
    INSERT INTO Orders(OrderPrice,Customer)VALUES('1640','Smith');
    INSERT INTO Orders(OrderPrice,Customer)VALUES('100','Robertson');
    INSERT INTO Orders(OrderPrice,Customer)VALUES('50','Williamson');
    INSERT INTO Orders(OrderPrice,Customer)VALUES('150','Smith');
    INSERT INTO Orders(OrderPrice,Customer)VALUES('250','Smith');
    INSERT INTO Orders(OrderPrice,Customer)VALUES('840','Brown');
    INSERT INTO Orders(OrderPrice,Customer)VALUES('440','Black');
    INSERT INTO Orders(OrderPrice,Customer)VALUES('20','Brown');
    COMMIT;

    Afterwards to query the data you would use :

    Select * From Orders;

    OR

    Select * From Cars;


    • Edited by a65001 Sunday, October 16, 2016 9:16 PM
    Sunday, October 16, 2016 9:16 PM
  • @a65001

    Thanks for the link

    I actually download.
    Really amazing as program, very complex, well-written, congratulations!
    I'll experience it in the following days.

    • Edited by YLedEditor Monday, October 17, 2016 12:50 AM
    Monday, October 17, 2016 12:50 AM
    Answerer