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
150
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
The programmers guide to timestamps and timezones - PyCon India 2023
shrayasr
0
95
A gentle introduction to types
shrayasr
1
130
The beauty that is PostgreSQL
shrayasr
2
310
Python, Imap & Gmail
shrayasr
2
210
Hylang - A Python powered Lisp AND a Lisp powered Python
shrayasr
2
610
My journey with the world of Open Source
shrayasr
1
190
Introduction to SQLAlchemy ORMs
shrayasr
1
250
Intro to Mac OSX
shrayasr
2
170
Android, A premiere
shrayasr
1
110
Other Decks in Technology
See All in Technology
サービス開発を前に進めるために 新米リードエンジニアが 取り組んだこと / Steps Taken by a Novice Lead Engineer to Advance Service Development
nologyance
0
180
データ分析を支える技術 生成AI再入門
ishikawa_satoru
0
380
AIアシスタントの活用で品質の向上と開発ワークフローのスピードアップ
nagix
1
200
Classmethod流のPlatform Engineering / classmethod-platform-engineering-devio2024
tomoki10
0
470
テスト・設計研修【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
170
LLMアプリケーションの評価の実践と課題 ~PharmaXにおける今後の展望~
pharma_x_tech
2
160
楽しくGoを学び合う、LayerXの勉強会文化 / LayerX's study culture of having fun and learning Go together
ar_tama
2
350
dxd2024-生成AIに振り回された3か月間の成功と失敗/dxd2024-link-and-motivation
lmi
2
260
AOAI Dev Day LLMシステム開発 Tips集
hirosatogamo
15
3.7k
開発と事業を繋ぐ!SREのオブザーバビリティ戦略 ~ Developers Summit 2024 Summer ~
leveragestech
0
630
OSSコミットしてZennの課題を解決した話
dyoshikawa1993
0
150
大規模ドラレコデータ収集・機械学習基盤を支える AWS CDK 〜導入・運用事例紹介〜
pemugi
0
110
Featured
See All Featured
Visualization
eitanlees
139
14k
Building Flexible Design Systems
yeseniaperezcruz
323
37k
Infographics Made Easy
chrislema
238
18k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
325
21k
Fontdeck: Realign not Redesign
paulrobertlloyd
79
5.1k
How STYLIGHT went responsive
nonsquared
93
5k
Faster Mobile Websites
deanohume
303
30k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
18
1.2k
Why You Should Never Use an ORM
jnunemaker
PRO
51
8.9k
Building Effective Engineering Teams - LeadDev
addyosmani
47
2.2k
Building Better People: How to give real-time feedback that sticks.
wjessup
357
18k
Happy Clients
brianwarren
94
6.5k
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.