Upgrade to Pro — share decks privately, control downloads, hide ads and more …

SeeQuaL

 SeeQuaL

My project , presented at The "Computer Society of India" day , March 2010

Shrayas Rajagopal

March 06, 2010
Tweet

More Decks by Shrayas Rajagopal

Other Decks in Technology

Transcript

  1. “Geek
    Programming
    .c .cs
    .css
    .php
    .cpp
    .m
    .html
    .java
    .js
    .sh
    *nix Stay up till 3 in the morning

    View full-size slide

  2. Design”
    T2
    Designs
    www.t2design.wordpress.com
    .ps
    .veg
    .aep

    View full-size slide

  3. Everything that can
    be invented has been invented.

    Charles H. Duell : 1899

    View full-size slide

  4. 640K
    ought to be enough for anybody.

    Bill Gates : 1981

    View full-size slide

  5. Windows NT
    addresses 2 Gigabytes of RAM,
    which is more than any
    application will ever need.

    Microsoft, on windows NT : 1992

    View full-size slide

  6. Lol
    Laugh out Loud

    View full-size slide

  7. “What?
    In under 15 seconds

    View full-size slide

  8. User Interface

    View full-size slide

  9. Specifically

    View full-size slide

  10. Manage Databases

    View full-size slide

  11. Three Databases

    View full-size slide

  12. SQLite MSSQL server

    View full-size slide

  13. SQLite MSSQL server MySql

    View full-size slide

  14. User
    One User

    View full-size slide

  15. SQLite SQL server MySql
    User

    View full-size slide

  16. SQLite SQL server MySql

    View full-size slide

  17. SQLite SQL server MySql

    View full-size slide

  18. SQLite SQL server MySql

    View full-size slide

  19. Local Machine

    View full-size slide

  20. Do you see a problem?

    View full-size slide

  21. 3 User Interfaces!?

    View full-size slide

  22. SQLite SQL server MySql

    View full-size slide

  23. Modules
    User Interface

    View full-size slide

  24. Modules
    User Interface
    Framework

    View full-size slide

  25. Collection of Classes

    View full-size slide

  26. sCore
    seequal + Core

    View full-size slide

  27. Non Specific

    View full-size slide

  28. Create a SQLite DB
    sql bar = new sql();

    View full-size slide

  29. Create a SQLite DB
    sql bar = new sql();
    bar.createSQLiteDatabase(‚foo.db‛);

    View full-size slide

  30. Wrong!
    sql bar = new sql();
    bar.createSQLiteDatabase(‚foo.db‛);

    View full-size slide

  31. Wrong!
    sql bar = new sql();
    bar.createSQLiteDatabase(‚foo.db‛);
    ‚CreateSQLiteDatabase(...)‛

    View full-size slide

  32. Wrong!
    sql bar = new sql();
    bar.createSQLiteDatabase(‚foo.db‛);
    ‚CreateSQLiteDatabase(...)‛
    Not the right way!

    View full-size slide

  33. Non Specific Addressing
    sql bar = new sql();

    View full-size slide

  34. Non Specific Addressing
    sql bar = new sql();
    bar.createOrOpenDatabase(‚foo.db‛);

    View full-size slide

  35. Non Specific Addressing
    sql bar = new sql();
    bar.createOrOpenDatabase(‚foo.db‛);
    The right way!

    View full-size slide

  36. bar.createOrOpenDatabase(‚foo.db‛);

    View full-size slide

  37. bar.createOrOpenDatabase(‚foo.db‛);
     SQLite

    View full-size slide

  38. bar.createOrOpenDatabase(‚foo.db‛);
     SQLite
     MSSQL Server

    View full-size slide

  39. bar.createOrOpenDatabase(‚foo.db‛);
     SQLite
     MSSQL Server
     MySql

    View full-size slide

  40. Non Specific

    View full-size slide

  41. Non Specific

    View full-size slide

  42. Non Specific
    Specific
    Specific

    View full-size slide

  43. Non Specific
    Specific
    Specific
    Abstracted

    View full-size slide

  44. You are on a need to know basis
    and You don’t need to know!

    “The Rock”
    Motto

    View full-size slide

  45. Communication is not only the
    essence of being human, but also
    a vital property of life.

    “John A. Piece”
    Motto

    View full-size slide

  46. Object
    Object

    View full-size slide

  47. Object
    Object
    Interprocess Communication

    View full-size slide

  48. Static class.

    View full-size slide

  49. Static class.

    View full-size slide

  50. Foo
    Bar
    Asdf
    Qwerty
    Static class.

    View full-size slide

  51. TableList foo = new TableList();

    View full-size slide

  52. TableList foo = new TableList();

    View full-size slide

  53. TableList foo = new TableList();
    AppBag

    View full-size slide

  54. Table Manager

    View full-size slide

  55. Create Table

    View full-size slide

  56. foo.PerformRefreshTables();

    View full-size slide

  57. foo.PerformRefreshTables();

    View full-size slide

  58. A few words…

    View full-size slide

  59. Querying?
    Multiline Querying

    View full-size slide

  60. Querying?
    Multiline Querying
    Query Builder

    View full-size slide

  61. Multiline Querying

    View full-size slide

  62. Multiline Querying

    View full-size slide

  63. Multiline Querying
    Select * from foobar;

    View full-size slide

  64. Multiline Querying
    Select * from foobar;
    ^temp = ‘Hello, world’
    Select substring(^temp,6) from dual;

    View full-size slide

  65. Multiline Querying
    Select * from foobar;
    ^temp = ‘Hello, world’
    Select substring(^temp,6) from dual;
    delete from foobar where id = 2;

    View full-size slide

  66. Query Builder

    View full-size slide

  67. Query Builder
    SQL dunce

    View full-size slide

  68. Query Builder
    SQL dunce

    View full-size slide

  69. Kudos!
    Alfy
    Terry
    Sham
    47 Andrew
    Vivek
    Jerry

    View full-size slide

  70. Kudos!
    Venkatalakshmi mam
    Jerald Sir

    View full-size slide