image a screenshot of http://www.qdb.us/67118
today:
Building applications with databases
HTTP
Net
Two-tier Architecture
SQL
Three-tier Architecture
on the Web
Old-school server-side
Modern, API-driven
User Interface
Business logic
Data storage
Security
Business logic
Security, validation
Thin client
Reload often
Generate HTML
Mix languages
Rich client
Great usability
Provide an API
Serve more static files
INSERT INTO Candidate VALUES
( 7, "Jane Smith", "1 Abe Ct. Cosham", "(02392) 555-001",
"js@g...com", "1979-01-02", "Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Aenean tincidunt dolor eu
rhoncus.", "y", 5);
SELECT name, phone
FROM Candidate
WHERE coID = 5;
############# file: index.php
<!doctype html>
<html>
<head>
<title>Item list</title>
<script src="js/functions.js"></script>
</head>
<body>
<?php include 'header.php';?>
...
<button onclick="deleteItem('<?php echo $itemNo;?>'">
...
<?php include 'footer.php';?>
</body>
</html>
Desktop
Mobile
Web
image of Tesla Model S interior from http://www.teslamotors.com/models
Picture of ATMs from https://sacredspaces2004.wordpress.com/2012/11/06/sacred-spaces-355-at-the-atm/
Picture of tesco scan-as-you-go scanner from http://mobile.pistonheads.com/gassing/topic.asp?h=0&f=192&t=1330248&nmt=Tescos+scan+as+you+shop
Picture of parcel scanner from http://www.dpd.com.pl/EN/subpage.asp?ID_kat=4&ID=50&Mark=11&Go=47&CATID=53
3-tier arch. advantages
- security
- scalability
- updates
disadvantages
- requires SW on server
- maintenance
- scalability
- complexity
- cost
Web advantages
- cross-platform
- simplicity
- clear network
- updates
- scalability
- popularity, reuse
disadvantages
- public network
- popularity
- statelessness
- testing
- browser
Web UI for Databases
Jo Smith | profile | log out
Add a Candidate
Jo Smith | profile | log out
Candidate interview list
| Company | Date ▼ | Result |
|---|---|---|
| IBM | Jan 20, 2017 | pending... |
| Specsavers | Jan 6, 2017 | rejected: lack of understanding of short-sighted people |
| McDonald's | Dec 5, 2016 | rejected: overqualified |
| BAE Systems | Aug 29, 2016 | rejected: no reason given |