Splice Machine Fundamentals

This section contains the following fundamental topics for Splice Machine developers:

Topic Describes
Running Transactions Introduces you to the basics of running transactions with Splice Machine.
Working with Dates Provides an overview of working with date and time values in Splice Machine.
Using Database Triggers Describes database triggers and how you can use them with Splice Machine.
Using Foreign Keys Describes our implementation of foreign keys and how our implementation ensures referential integrity.
Using Window Functions A quick summary of window functions, as implemented in Splice Machine SQL.
Using Temporary Tables Describes how to use temporary tables with Splice Machine.
Using the VTI Interface Allows you to use an SQL interface with data that is external to your database.
Using External Tables Describes the use of external tables (which are stored as flat files outside of your database) with Splice Machine.
Compaction and Vacuuming Describes how compaction and vacuuming are used to improve database performance.

The developer fundamentals topics that apply only to our on-premise-database product are in a separate subsection of this section.