Link
Embed
Share
Beginning
This slide
Copy link URL
Copy link URL
Copy iframe embed code
Copy iframe embed code
Copy javascript embed code
Copy javascript embed code
Share
Tweet
Share
Tweet
Slide 1
Slide 1 text
Hi!
Slide 2
Slide 2 text
Shrayas
Slide 3
Slide 3 text
“Geek Programming .c .cs .css .php .cpp .m .html .java .js .sh *nix Stay up till 3 in the morning
Slide 4
Slide 4 text
Design” T2 Designs www.t2design.wordpress.com .ps .veg .aep
Slide 5
Slide 5 text
No content
Slide 6
Slide 6 text
Everything that can be invented has been invented. “ Charles H. Duell : 1899
Slide 7
Slide 7 text
640K ought to be enough for anybody. “ Bill Gates : 1981
Slide 8
Slide 8 text
Windows NT addresses 2 Gigabytes of RAM, which is more than any application will ever need. “ Microsoft, on windows NT : 1992
Slide 9
Slide 9 text
Lol Laugh out Loud
Slide 10
Slide 10 text
No content
Slide 11
Slide 11 text
“What? In under 15 seconds
Slide 12
Slide 12 text
Simple
Slide 13
Slide 13 text
User Interface
Slide 14
Slide 14 text
Tool
Slide 15
Slide 15 text
Designed
Slide 16
Slide 16 text
Specifically
Slide 17
Slide 17 text
Developers
Slide 18
Slide 18 text
Manage Databases
Slide 19
Slide 19 text
Easy
Slide 20
Slide 20 text
Efficient
Slide 21
Slide 21 text
Way
Slide 22
Slide 22 text
Clear?
Slide 23
Slide 23 text
Three Databases
Slide 24
Slide 24 text
SQLite
Slide 25
Slide 25 text
SQLite MSSQL server
Slide 26
Slide 26 text
SQLite MSSQL server MySql
Slide 27
Slide 27 text
User One User
Slide 28
Slide 28 text
SQLite SQL server MySql User
Slide 29
Slide 29 text
SQLite SQL server MySql
Slide 30
Slide 30 text
SQLite SQL server MySql
Slide 31
Slide 31 text
SQLite SQL server MySql
Slide 32
Slide 32 text
No content
Slide 33
Slide 33 text
Local Machine
Slide 34
Slide 34 text
No content
Slide 35
Slide 35 text
Do you see a problem?
Slide 36
Slide 36 text
3 User Interfaces!?
Slide 37
Slide 37 text
No content
Slide 38
Slide 38 text
SeeQuaL
Slide 39
Slide 39 text
SeeQuaL
Slide 40
Slide 40 text
No content
Slide 41
Slide 41 text
No content
Slide 42
Slide 42 text
No content
Slide 43
Slide 43 text
No content
Slide 44
Slide 44 text
SeeQuaL
Slide 45
Slide 45 text
SQLite SQL server MySql
Slide 46
Slide 46 text
Modules
Slide 47
Slide 47 text
Modules User Interface
Slide 48
Slide 48 text
Modules User Interface Framework
Slide 49
Slide 49 text
Framework
Slide 50
Slide 50 text
Collection of Classes
Slide 51
Slide 51 text
No content
Slide 52
Slide 52 text
Sql
Slide 53
Slide 53 text
AppBag Sql
Slide 54
Slide 54 text
Sql
Slide 55
Slide 55 text
sCore
Slide 56
Slide 56 text
sCore seequal + Core
Slide 57
Slide 57 text
sCore
Slide 58
Slide 58 text
sCore
Slide 59
Slide 59 text
Non Specific
Slide 60
Slide 60 text
Create a SQLite DB sql bar = new sql();
Slide 61
Slide 61 text
Create a SQLite DB sql bar = new sql(); bar.createSQLiteDatabase(‚foo.db‛);
Slide 62
Slide 62 text
Wrong! sql bar = new sql(); bar.createSQLiteDatabase(‚foo.db‛);
Slide 63
Slide 63 text
Wrong! sql bar = new sql(); bar.createSQLiteDatabase(‚foo.db‛); ‚CreateSQLiteDatabase(...)‛
Slide 64
Slide 64 text
Wrong! sql bar = new sql(); bar.createSQLiteDatabase(‚foo.db‛); ‚CreateSQLiteDatabase(...)‛ Not the right way!
Slide 65
Slide 65 text
No content
Slide 66
Slide 66 text
Non Specific Addressing sql bar = new sql();
Slide 67
Slide 67 text
Non Specific Addressing sql bar = new sql(); bar.createOrOpenDatabase(‚foo.db‛);
Slide 68
Slide 68 text
Non Specific Addressing sql bar = new sql(); bar.createOrOpenDatabase(‚foo.db‛); The right way!
Slide 69
Slide 69 text
bar.createOrOpenDatabase(‚foo.db‛);
Slide 70
Slide 70 text
bar.createOrOpenDatabase(‚foo.db‛); SQLite
Slide 71
Slide 71 text
bar.createOrOpenDatabase(‚foo.db‛); SQLite MSSQL Server
Slide 72
Slide 72 text
bar.createOrOpenDatabase(‚foo.db‛); SQLite MSSQL Server MySql
Slide 73
Slide 73 text
No content
Slide 74
Slide 74 text
No content
Slide 75
Slide 75 text
Non Specific
Slide 76
Slide 76 text
Non Specific
Slide 77
Slide 77 text
Non Specific Specific Specific
Slide 78
Slide 78 text
Non Specific Specific Specific Abstracted
Slide 79
Slide 79 text
Motto
Slide 80
Slide 80 text
You are on a need to know basis and You don’t need to know! “ “The Rock” Motto
Slide 81
Slide 81 text
AppBag
Slide 82
Slide 82 text
Motto
Slide 83
Slide 83 text
Communication is not only the essence of being human, but also a vital property of life. “ “John A. Piece” Motto
Slide 84
Slide 84 text
Object
Slide 85
Slide 85 text
Object
Slide 86
Slide 86 text
Object Object
Slide 87
Slide 87 text
Object Object Interprocess Communication
Slide 88
Slide 88 text
AppBag
Slide 89
Slide 89 text
Static class.
Slide 90
Slide 90 text
Static class.
Slide 91
Slide 91 text
Foo Bar Asdf Qwerty Static class.
Slide 92
Slide 92 text
Table List
Slide 93
Slide 93 text
TableList foo = new TableList();
Slide 94
Slide 94 text
TableList foo = new TableList();
Slide 95
Slide 95 text
TableList foo = new TableList(); AppBag
Slide 96
Slide 96 text
Table Manager
Slide 97
Slide 97 text
Create Table
Slide 98
Slide 98 text
foo
Slide 99
Slide 99 text
No content
Slide 100
Slide 100 text
No content
Slide 101
Slide 101 text
No content
Slide 102
Slide 102 text
foo.PerformRefreshTables();
Slide 103
Slide 103 text
foo.PerformRefreshTables();
Slide 104
Slide 104 text
Gist.
Slide 105
Slide 105 text
AppBag
Slide 106
Slide 106 text
AppBag Sql
Slide 107
Slide 107 text
AppBag Sql
Slide 108
Slide 108 text
A few words…
Slide 109
Slide 109 text
Demo Time!
Slide 110
Slide 110 text
Querying?
Slide 111
Slide 111 text
Querying? Multiline Querying
Slide 112
Slide 112 text
Querying? Multiline Querying Query Builder
Slide 113
Slide 113 text
Multiline Querying
Slide 114
Slide 114 text
Multiline Querying
Slide 115
Slide 115 text
Multiline Querying Select * from foobar;
Slide 116
Slide 116 text
Multiline Querying Select * from foobar; ^temp = ‘Hello, world’ Select substring(^temp,6) from dual;
Slide 117
Slide 117 text
Multiline Querying Select * from foobar; ^temp = ‘Hello, world’ Select substring(^temp,6) from dual; delete from foobar where id = 2;
Slide 118
Slide 118 text
Query Builder
Slide 119
Slide 119 text
Query Builder SQL dunce
Slide 120
Slide 120 text
Query Builder SQL dunce
Slide 121
Slide 121 text
No content
Slide 122
Slide 122 text
Slide 123
Slide 123 text
No content
Slide 124
Slide 124 text
No content
Slide 125
Slide 125 text
[email protected]
Slide 126
Slide 126 text
Questions?
Slide 127
Slide 127 text
Kudos!
Slide 128
Slide 128 text
Kudos! Alfy Terry Sham 47 Andrew Vivek Jerry
Slide 129
Slide 129 text
Kudos! Venkatalakshmi mam Jerald Sir
Slide 130
Slide 130 text
Fin.