SQLite.swift: A Type-safe, Swift-language Layer Over SQLite3

SQLite.swift

A type-safe, Swift-language layer over SQLite3.

SQLite.swift provides compile-time confidence in SQL statement syntax and intent.

Features

• A pure-Swift interface
• A type-safe, optional-aware SQL expression builder
• A flexible, chainable, lazy-executing query layer
• Automatically-typed data access
• A lightweight, uncomplicated query and parameter binding interface
• Developer-friendly error handling and debugging
• Full-text search support
• Well-documented
• Extensively tested
• SQLCipher support via CocoaPods
• Works on Linux (with some limitations)
• Active support at StackOverflow, and Gitter Chat Room (experimental)

Usage

import SQLite

// Wrap everything in a do...catch to handle errors
do {
    let db = try Connection("path/to/db.sqlite3")

    let users = Table("users")
    let id = Expression<Int64>("id")
    let name = Expression<String?>("name")
    let email = Expression<String>("email")

    try db.run(users.create { t in
        t.column(id, primaryKey: true)
        t.column(name)
        t.column(email, unique: true)
    })
    // CREATE TABLE "users" (
    //     "id" INTEGER PRIMARY KEY NOT NULL,
    //     "name" TEXT,
    //     "email" TEXT NOT NULL UNIQUE
    // )

    let insert = users.insert(name <- "Alice", email <- "alice@mac.com")
    let rowid = try db.run(insert)
    // INSERT INTO "users" ("name", "email") VALUES ('Alice', 'alice@mac.com')

    for user in try db.prepare(users) {
        print("id: \(user[id]), name: \(user[name]), email: \(user[email])")
        // id: 1, name: Optional("Alice"), email: alice@mac.com
    }
    // SELECT * FROM "users"

    let alice = users.filter(id == rowid)

    try db.run(alice.update(email <- email.replace("mac.com", with: "me.com")))
    // UPDATE "users" SET "email" = replace("email", 'mac.com', 'me.com')
    // WHERE ("id" = 1)

    try db.run(alice.delete())
    // DELETE FROM "users" WHERE ("id" = 1)

    try db.scalar(users.count) // 0
    // SELECT count(*) FROM "users"
} catch {
    print (error)
}

SQLite.swift also works as a lightweight, Swift-friendly wrapper over the C API.

// Wrap everything in a do...catch to handle errors
do {
    // ...
    
    let stmt = try db.prepare("INSERT INTO users (email) VALUES (?)")
    for email in ["betty@icloud.com", "cathy@icloud.com"] {
        try stmt.run(email)
    }

    db.totalChanges    // 3
    db.changes         // 1
    db.lastInsertRowid // 3

    for row in try db.prepare("SELECT id, email FROM users") {
        print("id: \(row[0]), email: \(row[1])")
        // id: Optional(2), email: Optional("betty@icloud.com")
        // id: Optional(3), email: Optional("cathy@icloud.com")
    }

    try db.scalar("SELECT count(*) FROM users") // 2
} catch {
    print (error)
}

Read the documentation or explore more, interactively, from the Xcode project’s playground.

For a more comprehensive example, see this article and the companion repository.

Installation

Note: Version 0.11.6 and later requires Swift 5 (and Xcode 10.2) or greater. Version 0.11.5 requires Swift 4.2 (and Xcode 10.1) or greater.

Swift Package Manager

The Swift Package Manager is a tool for managing the distribution of Swift code.

1. Add the following to your Package.swift file:

dependencies: [
    .package(url: "https://github.com/stephencelis/SQLite.swift.git", from: "0.13.3")
]

1. Build your project:

$ swift build

See the Tests/SPM folder for a small demo project which uses SPM.

Carthage

Carthage is a simple, decentralized dependency manager for Cocoa. To install SQLite.swift with Carthage:

Make sure Carthage is installed.

Update your Cartfile to include the following:

github "stephencelis/SQLite.swift" ~> 0.13.3

Run carthage update and add the appropriate framework.

CocoaPods

CocoaPods is a dependency manager for Cocoa projects. To install SQLite.swift with CocoaPods:

Make sure CocoaPods is installed.

# Using the default Ruby install will require you to use sudo when
# installing and updating gems.
[sudo] gem install cocoapods

Update your Podfile to include the following:

use_frameworks!

target 'YourAppTargetName' do
    pod 'SQLite.swift', '~> 0.13.3'
end

Run pod install --repo-update.

Manual

To install SQLite.swift as an Xcode sub-project:

Drag the SQLite.xcodeproj file into your own project. (Submodule, clone, or download the project first.)

In your target’s General tab, click the + button under Linked Frameworks and Libraries.

Select the appropriate SQLite.framework for your platform.

Add.

Some additional steps are required to install the application on an actual device:

In the General tab, click the + button under Embedded Binaries.

Select the appropriate SQLite.framework for your platform.

Add.

Communication

See the planning document for a roadmap and existing feature requests.

Read the contributing guidelines. The TL;DR (but please; R):

• Need help or have a general question? Ask on Stack Overflow (tag sqlite.swift).
• Found a bug or have a feature request? Open an issue.
• Want to contribute? Submit a pull request.

Author

• Stephen Celis (@stephencelis)

License

SQLite.swift is available under the MIT license. See the LICENSE file for more information.

Related

These projects enhance or use SQLite.swift:

• SQLiteMigrationManager.swift (inspired by FMDBMigrationManager)
• Delta: Math helper (see Delta/Utils/Database.swift for production implementation example)

Alternatives

Looking for something else? Try another Swift wrapper (or FMDB):

• Camembert
• GRDB
• SQLiteDB
• Squeal
• SwiftData

---

Download Details:

Author: stephencelis
Source code: https://github.com/stephencelis/SQLite.swift

License: MIT license
#swift #sqlite 

What is GEEK

Buddha Community

10 Free Online Resources To Learn Swift Language

Swift is a fast and efficient general-purpose programming language that provides real-time feedback and can be seamlessly incorporated into existing Objective-C code. This is why developers are able to write safer, more reliable code while saving time. It aims to be the best language that can be used for various purposes ranging from systems programming to mobile as well as desktop apps and scaling up to cloud services.

Below here, we list down the 10 best online resources to learn Swift language.

(The list is in no particular order)

#developers corner #free online resources to learn swift language #learn swift #learn swift free #learn swift online free #resources to learn swift #swift language #swift programming

SQLite.swift: A Type-safe, Swift-language Layer Over SQLite3

SQLite.swift

A type-safe, Swift-language layer over SQLite3.

SQLite.swift provides compile-time confidence in SQL statement syntax and intent.

Features

• A pure-Swift interface
• A type-safe, optional-aware SQL expression builder
• A flexible, chainable, lazy-executing query layer
• Automatically-typed data access
• A lightweight, uncomplicated query and parameter binding interface
• Developer-friendly error handling and debugging
• Full-text search support
• Well-documented
• Extensively tested
• SQLCipher support via CocoaPods
• Works on Linux (with some limitations)
• Active support at StackOverflow, and Gitter Chat Room (experimental)

Usage

import SQLite

// Wrap everything in a do...catch to handle errors
do {
    let db = try Connection("path/to/db.sqlite3")

    let users = Table("users")
    let id = Expression<Int64>("id")
    let name = Expression<String?>("name")
    let email = Expression<String>("email")

    try db.run(users.create { t in
        t.column(id, primaryKey: true)
        t.column(name)
        t.column(email, unique: true)
    })
    // CREATE TABLE "users" (
    //     "id" INTEGER PRIMARY KEY NOT NULL,
    //     "name" TEXT,
    //     "email" TEXT NOT NULL UNIQUE
    // )

    let insert = users.insert(name <- "Alice", email <- "alice@mac.com")
    let rowid = try db.run(insert)
    // INSERT INTO "users" ("name", "email") VALUES ('Alice', 'alice@mac.com')

    for user in try db.prepare(users) {
        print("id: \(user[id]), name: \(user[name]), email: \(user[email])")
        // id: 1, name: Optional("Alice"), email: alice@mac.com
    }
    // SELECT * FROM "users"

    let alice = users.filter(id == rowid)

    try db.run(alice.update(email <- email.replace("mac.com", with: "me.com")))
    // UPDATE "users" SET "email" = replace("email", 'mac.com', 'me.com')
    // WHERE ("id" = 1)

    try db.run(alice.delete())
    // DELETE FROM "users" WHERE ("id" = 1)

    try db.scalar(users.count) // 0
    // SELECT count(*) FROM "users"
} catch {
    print (error)
}

SQLite.swift also works as a lightweight, Swift-friendly wrapper over the C API.

// Wrap everything in a do...catch to handle errors
do {
    // ...
    
    let stmt = try db.prepare("INSERT INTO users (email) VALUES (?)")
    for email in ["betty@icloud.com", "cathy@icloud.com"] {
        try stmt.run(email)
    }

    db.totalChanges    // 3
    db.changes         // 1
    db.lastInsertRowid // 3

    for row in try db.prepare("SELECT id, email FROM users") {
        print("id: \(row[0]), email: \(row[1])")
        // id: Optional(2), email: Optional("betty@icloud.com")
        // id: Optional(3), email: Optional("cathy@icloud.com")
    }

    try db.scalar("SELECT count(*) FROM users") // 2
} catch {
    print (error)
}

Read the documentation or explore more, interactively, from the Xcode project’s playground.

For a more comprehensive example, see this article and the companion repository.

Installation

Note: Version 0.11.6 and later requires Swift 5 (and Xcode 10.2) or greater. Version 0.11.5 requires Swift 4.2 (and Xcode 10.1) or greater.

Swift Package Manager

The Swift Package Manager is a tool for managing the distribution of Swift code.

1. Add the following to your Package.swift file:

dependencies: [
    .package(url: "https://github.com/stephencelis/SQLite.swift.git", from: "0.13.3")
]

1. Build your project:

$ swift build

See the Tests/SPM folder for a small demo project which uses SPM.

Carthage

Carthage is a simple, decentralized dependency manager for Cocoa. To install SQLite.swift with Carthage:

Make sure Carthage is installed.

Update your Cartfile to include the following:

github "stephencelis/SQLite.swift" ~> 0.13.3

Run carthage update and add the appropriate framework.

CocoaPods

CocoaPods is a dependency manager for Cocoa projects. To install SQLite.swift with CocoaPods:

Make sure CocoaPods is installed.

# Using the default Ruby install will require you to use sudo when
# installing and updating gems.
[sudo] gem install cocoapods

Update your Podfile to include the following:

use_frameworks!

target 'YourAppTargetName' do
    pod 'SQLite.swift', '~> 0.13.3'
end

Run pod install --repo-update.

Manual

To install SQLite.swift as an Xcode sub-project:

Drag the SQLite.xcodeproj file into your own project. (Submodule, clone, or download the project first.)

In your target’s General tab, click the + button under Linked Frameworks and Libraries.

Select the appropriate SQLite.framework for your platform.

Add.

Some additional steps are required to install the application on an actual device:

In the General tab, click the + button under Embedded Binaries.

Select the appropriate SQLite.framework for your platform.

Add.

Communication

See the planning document for a roadmap and existing feature requests.

Read the contributing guidelines. The TL;DR (but please; R):

• Need help or have a general question? Ask on Stack Overflow (tag sqlite.swift).
• Found a bug or have a feature request? Open an issue.
• Want to contribute? Submit a pull request.

Author

• Stephen Celis (@stephencelis)

License

SQLite.swift is available under the MIT license. See the LICENSE file for more information.

Related

These projects enhance or use SQLite.swift:

• SQLiteMigrationManager.swift (inspired by FMDBMigrationManager)
• Delta: Math helper (see Delta/Utils/Database.swift for production implementation example)

Alternatives

Looking for something else? Try another Swift wrapper (or FMDB):

• Camembert
• GRDB
• SQLiteDB
• Squeal
• SwiftData

---

Download Details:

Author: stephencelis
Source code: https://github.com/stephencelis/SQLite.swift

License: MIT license
#swift #sqlite 

SQLite Swift: A Type-safe, Swift-Language Layer Over SQLite3

SQLite.swift

A type-safe, Swift-language layer over SQLite3.

SQLite.swift provides compile-time confidence in SQL statement syntax and intent.

Features

• A pure-Swift interface
• A type-safe, optional-aware SQL expression builder
• A flexible, chainable, lazy-executing query layer
• Automatically-typed data access
• A lightweight, uncomplicated query and parameter binding interface
• Developer-friendly error handling and debugging
• Full-text search support
• Well-documented
• Extensively tested
• SQLCipher support via CocoaPods
• Works on Linux (with some limitations)
• Active support at StackOverflow, and Gitter Chat Room (experimental)

Usage

import SQLite

// Wrap everything in a do...catch to handle errors
do {
    let db = try Connection("path/to/db.sqlite3")

    let users = Table("users")
    let id = Expression<Int64>("id")
    let name = Expression<String?>("name")
    let email = Expression<String>("email")

    try db.run(users.create { t in
        t.column(id, primaryKey: true)
        t.column(name)
        t.column(email, unique: true)
    })
    // CREATE TABLE "users" (
    //     "id" INTEGER PRIMARY KEY NOT NULL,
    //     "name" TEXT,
    //     "email" TEXT NOT NULL UNIQUE
    // )

    let insert = users.insert(name <- "Alice", email <- "alice@mac.com")
    let rowid = try db.run(insert)
    // INSERT INTO "users" ("name", "email") VALUES ('Alice', 'alice@mac.com')

    for user in try db.prepare(users) {
        print("id: \(user[id]), name: \(user[name]), email: \(user[email])")
        // id: 1, name: Optional("Alice"), email: alice@mac.com
    }
    // SELECT * FROM "users"

    let alice = users.filter(id == rowid)

    try db.run(alice.update(email <- email.replace("mac.com", with: "me.com")))
    // UPDATE "users" SET "email" = replace("email", 'mac.com', 'me.com')
    // WHERE ("id" = 1)

    try db.run(alice.delete())
    // DELETE FROM "users" WHERE ("id" = 1)

    try db.scalar(users.count) // 0
    // SELECT count(*) FROM "users"
} catch {
    print (error)
}

SQLite.swift also works as a lightweight, Swift-friendly wrapper over the C API.

// Wrap everything in a do...catch to handle errors
do {
    // ...
    
    let stmt = try db.prepare("INSERT INTO users (email) VALUES (?)")
    for email in ["betty@icloud.com", "cathy@icloud.com"] {
        try stmt.run(email)
    }

    db.totalChanges    // 3
    db.changes         // 1
    db.lastInsertRowid // 3

    for row in try db.prepare("SELECT id, email FROM users") {
        print("id: \(row[0]), email: \(row[1])")
        // id: Optional(2), email: Optional("betty@icloud.com")
        // id: Optional(3), email: Optional("cathy@icloud.com")
    }

    try db.scalar("SELECT count(*) FROM users") // 2
} catch {
    print (error)
}

Read the documentation or explore more, interactively, from the Xcode project’s playground.

For a more comprehensive example, see this article and the companion repository.

Installation

Note: Version 0.11.6 and later requires Swift 5 (and Xcode 10.2) or greater. Version 0.11.5 requires Swift 4.2 (and Xcode 10.1) or greater.

Swift Package Manager

The Swift Package Manager is a tool for managing the distribution of Swift code.

1. Add the following to your Package.swift file:

dependencies: [
    .package(url: "https://github.com/stephencelis/SQLite.swift.git", from: "0.13.3")
]

2. Build your project:

$ swift build

See the Tests/SPM folder for a small demo project which uses SPM.

Carthage

Carthage is a simple, decentralized dependency manager for Cocoa. To install SQLite.swift with Carthage:

Make sure Carthage is installed.

Update your Cartfile to include the following:

github "stephencelis/SQLite.swift" ~> 0.13.3

Run carthage update and add the appropriate framework.

CocoaPods

CocoaPods is a dependency manager for Cocoa projects. To install SQLite.swift with CocoaPods:

Make sure CocoaPods is installed.

# Using the default Ruby install will require you to use sudo when
# installing and updating gems.
[sudo] gem install cocoapods

Update your Podfile to include the following:

use_frameworks!

target 'YourAppTargetName' do
    pod 'SQLite.swift', '~> 0.13.3'
end

Run pod install --repo-update.

Manual

To install SQLite.swift as an Xcode sub-project:

Drag the SQLite.xcodeproj file into your own project. (Submodule, clone, or download the project first.)

In your target’s General tab, click the + button under Linked Frameworks and Libraries.

Select the appropriate SQLite.framework for your platform.

Add.

Some additional steps are required to install the application on an actual device:

In the General tab, click the + button under Embedded Binaries.

Select the appropriate SQLite.framework for your platform.

Add.

Communication

See the planning document for a roadmap and existing feature requests.

Read the contributing guidelines. The TL;DR (but please; R):

• Need help or have a general question? Ask on Stack Overflow (tag sqlite.swift).
• Found a bug or have a feature request? Open an issue.
• Want to contribute? Submit a pull request.

Author

• Stephen Celis (@stephencelis)

License

SQLite.swift is available under the MIT license. See the LICENSE file for more information.

Related

These projects enhance or use SQLite.swift:

• SQLiteMigrationManager.swift (inspired by FMDBMigrationManager)
• Delta: Math helper (see Delta/Utils/Database.swift for production implementation example)

Alternatives

Looking for something else? Try another Swift wrapper (or FMDB):

• Camembert
• GRDB
• SQLiteDB
• Squeal
• SwiftData

Author: stephencelis
Source Code: https://github.com/stephencelis/SQLite.swift
License: MIT license

#ios #swift #sqlite 

Top Swift Development Companies | Top Swift Developers - TopDevelopers.co

A thoroughly researched list of top Swift developers with ratings & reviews to help find the best Swift development companies around the world.

#swift development service providers #best swift development companies #top swift development companies #swift development solutions #top swift developers #swift

Hire Dedicated Swift Developers

Want to create a native iOS application for your Startup?

Hire Dedicated Swift Developers for end-to-end services like development, migration, upgrade, testing, and support & maintenance. Trust HourlyDeveloper.io our Swift development team for iOS device apps that are high on performance and security.

Consult with experts:- https://bit.ly/2C5M6cz

#hire dedicated swift developers #swift developers #swift development company #swift development services #swift development #swift