Hi,

I wanted to update everyone on the status of my book's second edition.  It's not available quite yet.
I've just submitted the files to the publisher, and it will take a week or so to get the printed proof sent to a few test readers and a few weeks for review.

The book has more than 80 pages of new material based on feedback from myself and others and of course a few fixes.

I'd estimate at least 200 pages are on intermediate or advanced topics.  Unless you are Tim, you are guaranteed to learn something.  (This guarantee has no cash value.)

changes from first edition:

- numerous small updates

- new MultiLineEdit resizer - grow the text box as needed for responsive design

- new Image Resizer - demonstrates how to resize images as you please

- new Uploader example uploads a local file to server entirely in EWB Pascal
  - any file on PC/Mac/Unix
  - a web page can uploads pictures from Phones

- new Uploader2 example demonstrates how to overcome server upload imits
  - also create a progress bar showing upload progress
  - explains how to cancel an upload midway

- new OAuth2 example, uploads information to server, server validates user
  - creates a visitor log (updated on erickengelke.com already)

- new camera2 example Cordova/PhoneGAP phone app
  - take photos as before, and optionally upload them to server

- new chapter on serialization - about 15 pages
  - samples include arrays
  - sample shows how to serialize/deserialize all DateTimes to MySQL format replacing usual DateTime serialization

- new extended Camera optionally uploads pictures to PHP server - 6 pages

- much more on databases - about 20 pages
  - updated text
  - new sample EWB database client
  - new sample EWB database server using PHP/MySQL
     
So I suggest you hold off buying the book for about a month until we have the new version out.  On the other hand, the first edition will become a collector's edition so you might want to buy it while you still can.  Or of you need to get started before September, the first edition is pretty good - check Amazon reviews.

Erick

Table of Contents for those interested
Sorry, when I copy this from the PDF all the characters became capitals.

DEDICATION .......................................................................................................................9
SPECIAL THANKS ............................................................................................................... 10
STARTING THOUGHTS ....................................................................................................... 11
   WHY OBJECT PASCAL.......................................................................................................... 12  
   MORE ON EWB ................................................................................................................ 12
THE BASICS ....................................................................................................................... 14
   INTRODUCTION TO OBJECT PASCAL AS USED IN EWB .................................................................. 14
   ARRAYS........................................................................................................................... 15
  OPERATORS ..................................................................................................................... 16
  ORDER OF OPERATIONS....................................................................................................... 16
  CLASSES .......................................................................................................................... 16
  SCOPE ............................................................................................................................ 19
  CASTING.......................................................................................................................... 20
  EXCEPTION HANDLING ........................................................................................................ 21  
  EXTERNAL INTERFACES ........................................................................................................ 23
  MESSAGE QUEUE AND ASYNC METHODS ................................................................................. 23
  TSTRINGS ........................................................................................................................ 23
CREATING AN APPLICATION .............................................................................................. 25
   THE TOOL ........................................................................................................................ 25
  CREATING THE APP ............................................................................................................ 26
MULTI-FORM APPLICATIONS ............................................................................................. 33
STANDARD VISUAL CLASSES .............................................................................................. 36
   TLABEL ........................................................................................................................... 36
   TBALLOONLABEL ............................................................................................................... 37
   TALERTLABEL ................................................................................................................... 37
   TBUTTON ........................................................................................................................ 37
   TICONBUTTON.................................................................................................................. 37
   TDIALOGBUTTON .............................................................................................................. 38
   TCHECKBOX ..................................................................................................................... 38
   TRADIOBUTTON................................................................................................................ 39
   TEDIT ............................................................................................................................. 39
   TPASSWORDEDIT .............................................................................................................. 39
   TMULTILINEEDIT............................................................................................................... 40
   TCALENDAR ..................................................................................................................... 40
   TBUTTONCOMBOBOX ........................................................................................................ 40
   TLISTBOX ........................................................................................................................ 41   
   TDATEEDITCOMBOBOX ...................................................................................................... 41
   TDIALOGEDITCOMBOBOX ................................................................................................... 41
   TFILECOMBOBOX .............................................................................................................. 42
   TGRID ............................................................................................................................ 42
GRAPHICS CONTROLS ........................................................................................................ 43
   TIMAGE .......................................................................................................................... 43
   TICON ............................................................................................................................ 43
   TANIMATEDICON .............................................................................................................. 43
   TPAINT ........................................................................................................................... 43
   TSLIDESHOW.................................................................................................................... 43
INDICATORS...................................................................................................................... 45
   TPROGRESSBAR ................................................................................................................ 45
MULTIMEDIA .................................................................................................................... 46
   TAUDIO .......................................................................................................................... 46
   TVIDEO........................................................................................................................... 46
CONTAINERS ..................................................................................................................... 47
   THEADERPANEL ................................................................................................................ 47
   TBASICPANEL ................................................................................................................... 47
    TPANEL........................................................................................................................... 47
   TPAGE ............................................................................................................................ 47
   TPAGEPANEL.................................................................................................................... 48
   TSCROLLPANEL ................................................................................................................. 48
   THTMLFORM .................................................................................................................. 48
   TSIZER ............................................................................................................................ 48
   TSIZEGRIP ....................................................................................................................... 48
MENUS ............................................................................................................................. 50
   TMENU .......................................................................................................................... 50
TOOLBARS ........................................................................................................................ 51
   TTOOLBAR ...................................................................................................................... 51
  TDATASETTOOLBAR........................................................................................................... 51
WEB ................................................................................................................................. 52
   TLINK ............................................................................................................................. 52
   TBROWSER ...................................................................................................................... 52
   TSCRIPT .......................................................................................................................... 52
   TMAP ............................................................................................................................ 52
SYSTEM ............................................................................................................................ 53
   TTIMER........................................................................................................................... 53
LAYOUT OF VISUAL CONTROLS .......................................................................................... 54
   WYSIWYG LAYOUT ........................................................................................................... 54
   DESKTOP AND MOBILE....................................................................................................... 54
CONDITIONAL COMPILATION ............................................................................................ 58
LOCAL AND SESSION STORAGE .......................................................................................... 59
DEBUGGING...................................................................................................................... 62
   EXCEPTIONS ..................................................................................................................... 62
   SHOWMESSAGE ................................................................................................................ 63
   CONSOLE.LOG .................................................................................................................. 63
   JAVASCRIPT DEBUGGING ..................................................................................................... 63
DEWBUNIT UNIT TESTING .................................................................................................. 64
   REAL WORLD DEWBUNIT TESTING........................................................................................ 67
PAINTING.......................................................................................................................... 69
   TCANVASELEMENT ............................................................................................................ 75
   TCANVASELEMENT PROPERTIES............................................................................................. 75
   TCANVASELEMENT METHODS............................................................................................... 77
   RESIZING IMAGES .............................................................................................................. 81
UPLOADING AND DOWNLOADING..................................................................................... 85
   UPLOADING FILES .............................................................................................................. 85
   DOWNLOADING DATA FILES ................................................................................................. 86
EWB EVENT DRIVEN MODEL .............................................................................................. 88
   ASYNC CALLS .................................................................................................................... 89
THE MIGHTY TAG PROPERTY ............................................................................................. 92
DATETIME......................................................................................................................... 93
ANIMATIONS .................................................................................................................... 95
TGRID – YOUR OWN GRIDS ............................................................................................. 101
EXTENDING CONTROLS ................................................................................................... 102
   QUICK AND DIRTY METHOD OF EXTENDING CONTROLS .............................................................. 102
   Grids with Color ....................................................................................................... 107
PERSISTENCE AND SERIALIZATION/DESERIALIZATION ...................................................... 111
   DATETIME AND TREADER/TWRITER ..................................................................................... 115
   PUBLISHED PROPERTIES..................................................................................................... 116
   PERSISTENT ARRAYS ......................................................................................................... 118
   DATETIME SERIALIZING AND DESERIALIZING WITH MYSQL ......................................................... 128
DATABASES..................................................................................................................... 135
   TDATABASE ................................................................................................................... 135
   TDATASET ..................................................................................................................... 135
   LOADCOLUMNS .............................................................................................................. 136
   LOADROWS ................................................................................................................... 136
   FIRST, PRIOR, NEXT AND LAST ............................................................................................. 136
   INSERT, UPDATE, DELETE AND SAVE ..................................................................................... 136
   FIND AND SORT ............................................................................................................... 137
   STARTING SIMPLE ............................................................................................................ 137
   JSON: MACHINES AND PEOPLE ........................................................................................... 139
   TRANSACTIONS – DONE MANUALLY ..................................................................................... 139
   TRANSACTIONS – AUTOMATIC ............................................................................................ 140
   REREADING DATA ROWS ................................................................................................... 141    
   PHP/MYSQL DATABASES ................................................................................................. 142
   REST ........................................................................................................................... 142
   EXAMPLE EWB WEB DATABASE CLIENT ................................................................................ 144
   PHP SERVER CODE .......................................................................................................... 148
   MULTIPLE-TABLE OPERATIONS ............................................................................................ 154
   DATABASE PRIVILEGES ...................................................................................................... 155  
   MORE ON BLOBS ........................................................................................................... 155
WEB SERVERS ................................................................................................................. 157
   ENSURING HTTPS ........................................................................................................... 158
   ADDING A SIMPLE PHP RPC SERVER .................................................................................... 159
JAVASCRIPT RELATED TOPICS .......................................................................................... 175
   FEW RULES: WEBDOM, TYPE AND VAR ................................................................................. 175
   OF CLASS OBJECT AND TOBJECT .......................................................................................... 175
   VARIANTS AND OBJECTS .................................................................................................... 177
   EXTERNAL PROCEDURES AND FUNCTIONS............................................................................... 177
   EXTERNAL CLASSES........................................................................................................... 178
   DOCUMENT OBJECT MODEL (DOM) .................................................................................... 179
   REDIRECTING TO A DIFFERENT WEB PAGE .............................................................................. 184
   LOADING EXTERNAL JAVASCRIPT LIBRARIES ............................................................................ 184
   READING LOCAL FILES ....................................................................................................... 187
   UPLOADING LOCAL FILES ................................................................................................... 192
   UPLOADER2 – PROGRESSBAR SHOWING PROGRESS.................................................................. 199  
  WRITING LOCAL FILES ....................................................................................................... 209
  SMOOTHIE SCROLLING CHARTS ........................................................................................... 216
  GOOGLE CHARTS ............................................................................................................. 220
   OAUTH 2.0 WITH HELLO.JS ............................................................................................... 224
   SHARING OAUTH2 TOKENS ................................................................................................ 232
JAVASCRIPT SUMMARY ..................................................................................................... 240
MULTITHREADING – YES, ACTUAL THREADS..................................................................... 242
   CALLING EWB ROUTINES FROM PLAIN OLD JAVASCRIPT ............................................................ 250   
   WRITING THE MAIN THREAD/GUI IN EWB ............................................................................ 250
   REAL USES OF THREADS .................................................................................................... 253
CORDOVA / PHONEGAP / MOBILE APPLICATIONS ............................................................ 254
   SETUP........................................................................................................................... 254
   TOOLKITS INSTALLATION .................................................................................................... 255
   DISTRIBUTION................................................................................................................. 255
   CONFIGURING YOUR APP................................................................................................... 255
   CORDOVA EXAMPLES ........................................................................................................ 256
   CAMERA EXAMPLE ........................................................................................................... 257
   CAMERA WITH PICTURE UPLOAD ......................................................................................... 265
   MAP AND GPS EXAMPLE ................................................................................................... 271
   MORE EXTENSIONS .......................................................................................................... 277
   NEXT STEPS.................................................................................................................... 278
CONCLUSION .................................................................................................................. 279
INDEX ............................................................................................................................. 282

Terrific work, Erick!  Invaluable to all of us :D

Boris B wrote:
> Terrific work, Erick!  Invaluable to all of us :D

Thanks Boris.  

If anyone has other suggestions please send them to me as I still have time to add things.

In response to Tim's lack of luck with PHP/MySQL, I added my basic PHP framework that responds to EWB's standard SOA requests.  It's enough to get you started with PHP/MySQL hosted solutions.  It's not as complete as Tim was working on, but it is enough for my needs and I suspect many other people's.  Out of the box it generates the SQL, but you edit the basic CRUD (create, read, update, delete) functions to impose your business rules.

Other PHP/MySQL-specific features include serializing and deserializing datetime <--> MySQL datetime and OAuth2 identity server validation.  But I didn't do localization (and various other important parts).   By listing the limitations out front, I hope people can live with this simple framework.

Erick

Awesome

will be ordering the second edition

Thank you

Thanks Eric, I will be buying the 2nd edition as soon as it's out.

= Steve

<< Thanks Eric, I will be buying the 2nd edition as soon as it's out. >>

Oops, sorry. That should have been "Erick".

Erick

Another chapter for the book would be using a WYSIWYG editor.

https://github.com/cheeaun/mooeditable/wiki/Javascript-WYSIWYG-editors

Quilljs.com looks interesting....

Walter

Walter Matte wrote:
>Another chapter for the book would be using a WYSIWYG editor.
>
>https://github.com/cheeaun/mooeditable/wiki/Javascript-WYSIWYG-editors

I was looking at that a week ago for a project and decided on CK Editor.  Then I forgot to put it in the book, so thanks for reminding me.

I put up a sample at:
http://erickengelke.com/ewb/richedit/rich.html

It doesn't have all the functionality because I had trouble uploading all the files through the FTP interface.

Erick

erickengelke wrote:

> I was looking at that a week ago for a project and decided on CK
> Editor.  Then I forgot to put it in the book, so thanks for reminding
> me.

Can you finish my project for me too? 8-)

This is going to encapsulate a lot of good information. Well done!

--

Matthew Jones