The DB Sync framework 5.01

Content
Search Results
Index
Loading, please wait ...

Loading

  • DB Sync framework purpose
  • What's new in DB Sync
  • Concepts
    • DB Sync framework purpose
    • Actors of DB Sync
    • DB Sync architecture
    • DB Sync objects
    • Application SQL tables
    • User authentication and permissions
    • The synchronization mechanism
    • Concurrent data access conflicts
    • Data filters
    • DB Sync implementation tasks
  • Installation
    • Software Requirements
    • Package installation
    • Locale settings
  • Set Up
    • Before starting with setup
    • Set up DB Sync with GAS/GIP
      • Prepare the GAS for DB Sync
      • Configure GIP for DB Sync
      • Set up the server configuration file
      • Set up the database schema file
      • Create DB Sync client apps
      • Create DB Sync users
      • DB Sync GAS/GIP setup test
    • Set up DB Sync in direct mode
    • Set up DB Sync for server-side apps
    • DB Sync system tables
    • Database maintenance
  • Configuration files
    • Server configuration file
    • Client configuration file
  • Database schema reference
    • SQL table definition
    • SQL column definition
    • Auto incremented columns
    • Relations between SQL tables
  • Administration consoles
    • Database schema editor
      • Schema definitions
      • SQL table properties
      • SQL column properties
      • Auto-incremented columns
      • Foreign key properties
    • Apps definition console
      • App definitions
      • Associating tables to apps
      • App/Table permissions
      • Defining data filters
    • Users definition console
      • User definitions
      • Associating apps to users
      • User/App/Table permissions
      • Data filter parameter values
    • Change log viewer
  • Implementing a DB Sync server-side app
    • Concepts for DB Sync server-side apps
    • Step-by-step DB Sync server-side app implementation
      • Import the DB Sync API modules
      • Initialize the DB Sync API
      • Register the schema, app and user
      • Connect to the central database
      • Registering changes in the DB Sync central change log
      • Clean up the DB Sync API
  • Implementing a DB Sync client app
    • Concepts for DB Sync client apps
    • Step-by-step DB Sync client app implementation
      • Import the DB Sync API modules
      • Initialize the DB Sync API
      • Declare the database schema
      • Initialize the SQLite local database
      • Register sync source parameters
      • User authentication in direct mode
      • User authenticating with GAS/SSO/GIP
      • Declare application SQL tables
      • Data changes: Row creation (INSERT)
      • Data changes: Row change (UPDATE)
      • Data changes: Row removal (DELETE)
      • Synchronizing with central database
      • Cleanup the DB Sync API
  • Commands reference
    • dbsync_tool
    • dbsync_schema
    • dbsync_setup
    • dbsync_server
    • dbsync_app_conf
    • dbsync_user_conf
  • DB Sync demos
    • Books demo
  • DB Sync API reference
    • dbsync_core: Core module
      • dbsync_core.t_dbsync_source type
      • dbsync_core.t_dbsync_event type
      • dbsync_core.t_dbsync_event_array type
      • dbsync_core.t_app_id type
      • dbsync_core.t_user_id type
      • dbsync_core.t_user_auth type
      • dbsync_core.t_user_name type
      • dbsync_core.t_user_status type
      • dbsync_core.t_user type
      • dbsync_core.t_user_ident type
      • dbsync_core.t_mtime type
      • dbsync_core.t_table_name type
      • dbsync_core.t_tabinfo type
      • dbsync_core.t_tabinfo_rec type
      • dbsync_core.enter_user_credentials()
      • dbsync_core.read_dbsync_source_file()
    • dbsync_app: Client app module
      • dbsync_app.apply_data_changes()
      • dbsync_app.cleanup()
      • dbsync_app.collect_local_changes()
      • dbsync_app.collect_local_pkeys()
      • dbsync_app.compact_local_changes()
      • dbsync_app.data_reset()
      • dbsync_app.data_sync()
      • dbsync_app.data_sync_init()
      • dbsync_app.data_sync_retrieve()
      • dbsync_app.data_sync_send()
      • dbsync_app.data_sync_set_full_sync()
      • dbsync_app.data_sync_set_return_receipt()
      • dbsync_app.get_database_copy()
      • dbsync_app.get_user_info()
      • dbsync_app.get_app_tables()
      • dbsync_app.get_result_events()
      • dbsync_app.initialize()
      • dbsync_app.is_row_referenced()
      • dbsync_app.new_temp_autoincr()
      • dbsync_app.register_dbsync_source()
      • dbsync_app.register_dbsync_user()
      • dbsync_app.register_local_change()
      • dbsync_app.register_local_change_cpk2()
      • dbsync_app.register_local_change_cpk3_s()
      • dbsync_app.register_local_change_s()
      • dbsync_app.register_local_dbschema()
      • dbsync_app.register_local_delete()
      • dbsync_app.register_local_delete_cpk2()
      • dbsync_app.register_local_delete_cpk3_s()
      • dbsync_app.register_local_delete_s()
      • dbsync_app.register_local_insert()
      • dbsync_app.register_local_insert_cpk2()
      • dbsync_app.register_local_insert_cpk3_s()
      • dbsync_app.register_local_insert_s()
      • dbsync_app.register_local_tables()
      • dbsync_app.register_local_update()
      • dbsync_app.register_local_update_cpk2()
      • dbsync_app.register_local_update_cpk3_s()
      • dbsync_app.register_local_update_s()
      • dbsync_app.send_return_receipt()
    • dbsync_srvapp: Server app module
      • dbsync_srvapp.central_change_cancel()
      • dbsync_srvapp.central_change_done()
      • dbsync_srvapp.central_change_init()
      • dbsync_srvapp.central_set_sync_timestamp()
      • dbsync_srvapp.cleanup()
      • dbsync_srvapp.initialize()
      • dbsync_srvapp.is_row_referenced()
      • dbsync_srvapp.register_central_app_params()
      • dbsync_srvapp.register_central_delete()
      • dbsync_srvapp.register_central_delete_cpk2()
      • dbsync_srvapp.register_central_delete_cpk3_s()
      • dbsync_srvapp.register_central_delete_s()
      • dbsync_srvapp.register_central_insert()
      • dbsync_srvapp.register_central_insert_cpk2()
      • dbsync_srvapp.register_central_insert_cpk3_s()
      • dbsync_srvapp.register_central_insert_s()
      • dbsync_srvapp.register_central_update()
      • dbsync_srvapp.register_central_update_cpk2()
      • dbsync_srvapp.register_central_update_cpk3_s()
      • dbsync_srvapp.register_central_update_s()