Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
SeeQuaL
Search
Shrayas Rajagopal
March 06, 2010
Technology
1
190
SeeQuaL
My project , presented at The "Computer Society of India" day , March 2010
Shrayas Rajagopal
March 06, 2010
Tweet
Share
More Decks by Shrayas Rajagopal
See All by Shrayas Rajagopal
Embrace the Grind
shrayasr
0
100
The programmers guide to timestamps and timezones - PyCon India 2023
shrayasr
0
150
A gentle introduction to types
shrayasr
1
140
The beauty that is PostgreSQL
shrayasr
2
330
Python, Imap & Gmail
shrayasr
2
230
Hylang - A Python powered Lisp AND a Lisp powered Python
shrayasr
2
740
My journey with the world of Open Source
shrayasr
1
200
Introduction to SQLAlchemy ORMs
shrayasr
1
280
Intro to Mac OSX
shrayasr
2
180
Other Decks in Technology
See All in Technology
「魔法少女まどか☆マギカ Magia Exedra」の必殺技演出を徹底解剖! -キャラクターの魅力を最大限にファンに届けるためのこだわり-
gree_tech
PRO
0
340
kintone開発チームの紹介
cybozuinsideout
PRO
0
73k
ヒューリスティック評価を用いたゲームQA実践事例
gree_tech
PRO
0
340
Yahoo!広告ビジネス基盤におけるバックエンド開発
lycorptech_jp
PRO
2
320
エキサイトブログの トップページを 段階的にリプレイスする
zsp2088dev
0
150
JavaScript 研修
recruitengineers
PRO
6
1.3k
実運用で考える PGO
kworkdev
PRO
0
120
「魔法少女まどか☆マギカ Magia Exedra」での負荷試験の実践と学び
gree_tech
PRO
0
340
Product Management Conference -AI時代に進化するPdM-
kojima111
0
270
Goss: Faiss向けの新しい本番環境対応 Goバインディング #coefl_go_jp
bengo4com
1
1.4k
実践アプリケーション設計 ③ドメイン駆動設計
recruitengineers
PRO
13
3.7k
Goss: New Production-Ready Go Binding for Faiss #coefl_go_jp
bengo4com
1
1.1k
Featured
See All Featured
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
61k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
50k
StorybookのUI Testing Handbookを読んだ
zakiyama
30
6.1k
GraphQLの誤解/rethinking-graphql
sonatard
71
11k
Testing 201, or: Great Expectations
jmmastey
45
7.6k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
8
900
Done Done
chrislema
185
16k
Documentation Writing (for coders)
carmenintech
73
5k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
367
27k
Music & Morning Musume
bryan
46
6.8k
Raft: Consensus for Rubyists
vanstee
140
7.1k
Product Roadmaps are Hard
iamctodd
PRO
54
11k
Transcript
Hi!
Shrayas
“Geek Programming .c .cs .css .php .cpp .m .html .java
.js .sh *nix Stay up till 3 in the morning
Design” T2 Designs www.t2design.wordpress.com .ps .veg .aep
None
Everything that can be invented has been invented. “ Charles
H. Duell : 1899
640K ought to be enough for anybody. “ Bill Gates
: 1981
Windows NT addresses 2 Gigabytes of RAM, which is more
than any application will ever need. “ Microsoft, on windows NT : 1992
Lol Laugh out Loud
None
“What? In under 15 seconds
Simple
User Interface
Tool
Designed
Specifically
Developers
Manage Databases
Easy
Efficient
Way
Clear?
Three Databases
SQLite
SQLite MSSQL server
SQLite MSSQL server MySql
User One User
SQLite SQL server MySql User
SQLite SQL server MySql
SQLite SQL server MySql
SQLite SQL server MySql
None
Local Machine
None
Do you see a problem?
3 User Interfaces!?
None
SeeQuaL
SeeQuaL
None
None
None
None
SeeQuaL
SQLite SQL server MySql
Modules
Modules User Interface
Modules User Interface Framework
Framework
Collection of Classes
None
Sql
AppBag Sql
Sql
sCore
sCore seequal + Core
sCore
sCore
Non Specific
Create a SQLite DB sql bar = new sql();
Create a SQLite DB sql bar = new sql(); bar.createSQLiteDatabase(‚foo.db‛);
Wrong! sql bar = new sql(); bar.createSQLiteDatabase(‚foo.db‛);
Wrong! sql bar = new sql(); bar.createSQLiteDatabase(‚foo.db‛); ‚CreateSQLiteDatabase(...)‛
Wrong! sql bar = new sql(); bar.createSQLiteDatabase(‚foo.db‛); ‚CreateSQLiteDatabase(...)‛ Not the
right way!
None
Non Specific Addressing sql bar = new sql();
Non Specific Addressing sql bar = new sql(); bar.createOrOpenDatabase(‚foo.db‛);
Non Specific Addressing sql bar = new sql(); bar.createOrOpenDatabase(‚foo.db‛); The
right way!
bar.createOrOpenDatabase(‚foo.db‛);
bar.createOrOpenDatabase(‚foo.db‛); SQLite
bar.createOrOpenDatabase(‚foo.db‛); SQLite MSSQL Server
bar.createOrOpenDatabase(‚foo.db‛); SQLite MSSQL Server MySql
None
None
Non Specific
Non Specific
Non Specific Specific Specific
Non Specific Specific Specific Abstracted
Motto
You are on a need to know basis and You
don’t need to know! “ “The Rock” Motto
AppBag
Motto
Communication is not only the essence of being human, but
also a vital property of life. “ “John A. Piece” Motto
Object
Object
Object Object
Object Object Interprocess Communication
AppBag
Static class.
Static class.
Foo Bar Asdf Qwerty Static class.
Table List
TableList foo = new TableList();
TableList foo = new TableList();
TableList foo = new TableList(); AppBag
Table Manager
Create Table
foo
None
None
None
foo.PerformRefreshTables();
foo.PerformRefreshTables();
Gist.
AppBag
AppBag Sql
AppBag Sql
A few words…
Demo Time!
Querying?
Querying? Multiline Querying
Querying? Multiline Querying Query Builder
Multiline Querying
Multiline Querying
Multiline Querying Select * from foobar;
Multiline Querying Select * from foobar; ^temp = ‘Hello, world’
Select substring(^temp,6) from dual;
Multiline Querying Select * from foobar; ^temp = ‘Hello, world’
Select substring(^temp,6) from dual; delete from foobar where id = 2;
Query Builder
Query Builder SQL dunce
Query Builder SQL dunce
None
</SeeQuaL>
None
None
[email protected]
Questions?
Kudos!
Kudos! Alfy Terry Sham 47 Andrew Vivek Jerry
Kudos! Venkatalakshmi mam Jerald Sir
Fin.