Connect sets up the database connection, using the configured ConnectionString, and ensures it is working.

Delete will delete the element, and will also delete duplicates.

Exists checks if a row where haystack matches the needle exists on the given table.

Get is a convenience-wrapper for Select that return suitable gondulapi-errors if the needle is the Zero-value, if the database-query fails or if the item isn't found.

Insert adds the object to the table specified.

Ping is a wrapper for DB.Ping: it checks that the database is alive.

Select populates the provided interface(should be a pointer to a struct) by performing a simple select on the table, matching haystack with needle.

SelectMany selects multiple rows from the table, populating the slice pointed to by d.

Update attempts to update the object in the database, using the provided string and matching the haystack with the needle.

Upsert makes database-people cringe by first checking if an element exists, if it does, it is updated.

DB is the main database handle used throughout the API.