• Home
  • Troubleshoot
  • #Example
    • C
    • C++
    • Python
    • R-Programming
  • DSA
  • Quiz
  • Tutorial Videos
  • Home
  • Troubleshoot
  • #Example
    • C
    • C++
    • Python
    • R-Programming
  • DSA
  • Quiz
  • Tutorial Videos
  • #Deals
  • #News
  • #WiKi
  • #APPS
  • #Events
    • #WWDC
    • #I/O
    • #Ignite
  • #Let’s Talk

MyCodeTips mycodetips-newlogocopy1

  • Home
  • Troubleshoot
  • #Example
    • C
    • C++
    • Python
    • R-Programming
  • DSA
  • Quiz
  • Tutorial Videos
Database, IOS

SQLite3 database connection functions and commands !

sqlite3_open() – will result in a database with the default UTF-8 encoding.

sqlite3_open_v2() – will result in a database with the default UTF-8 encoding.

sqlite3_open_16() – is used to create a database, the default string encoding will be UTF-16 in the native byte order of the machine.

sqlite3_close() – To close and release a database connection.

sqlite3_errmsg() – This allows the caller to retrive an error message.

sqlite3_stmt – Once a database connection is established, we can start to execute SQL commands. This is normally done by preparing and stepping through statements.

sqlite3_prepare_v2() – The prepare process converts an SQL command string into a prepared statement.

*note : Preparing an SQL statement causes the command string to be parsed and converted into a set of byte-code commands. This byte-code is fed into SQLite’s Virtual Database Engine (VDBE) for execution.

sqlite3_step() – To execute the VDBE code.

sqlite3_column_count() – Returns the number of columns in the statement result.

sqlite3_column_name()/sqlite3_column_name16() – returns the name of the specified column as a UTF8 or UTF16 encoded string.

sqlite3_finalize() – Destroy A Prepared Statement Object

sqlite3_reset() – Reset A Prepared Statement Object

sqlite3_free() – Memory Allocation Subsystem

sqlite3_column_type() – return the native type (strong class) of the value found in the specified column.

sqlite3_column_blob() – returns a pointer to the BLOB value from the given column.

sqlite3_column_double() – returns a 64-bit floating-point value from the given column.

sqlite3_column_int() – returns a 32-bit signed integer from the given column.

sqlite3_column_int64() – return a 64-bit signed integer from the given column.

sqlite3_column_text()/sqlite3_column_text16() – returns a pointer to a UTF-8 or UTF-16 encoded string from the given column.

sqlite3_column_value() – returns a pointer to an unprotected sqlite3_value.

sqlite3_column_type – to return undefined results.

sqlite3_column_bytes() – returns the number of byte in a BLOB or in a UTF-8 text value.

sqlite3_column_bytes16() – returns the number of bytes in UTF-16 encoded text value,including the terminator.

sqlite3_reset() – reset a prepared statements so that it is ready for another execution.

  • Click to share on Reddit (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Pocket (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
Written by Ranjan - 1967 Views
AUTHOR
Ranjan

I m Ranjan and Sharing my years of experience in Software Development. Love to code in Mobile apps (IOS, Android, Power Apps, Xamarin, Flutter), Machine Learning ( Beginner ), Dot Net, Databases ( SQL Server, MySql, SQLite), WordPress, Cloud Computing ( AWS, Azure, Google, MongoDB) and many more as required on project-specific. Besides this love to travel and cook.

Next Post
Previous Post

Subscribe for updates

Join 6,873 other subscribers

whiteboard

Whiteboard(PRO)

whiteboard

Whiteboard(lite)

alphabets

Kids Alphabet

techlynk

Techlynk

techbyte

Do2Day

techbyte

Techbyte

Latest Posts

  • Frameworks of IOS
    Frameworks of IOS – Part ( I )
  • NSFileManager or NSPathUtilities
    NSFileManager or NSPathUtilities in Objective-C
  • Passing data between view controllers in Objective-C
    Passing data between view controllers in Objective-C
  • structures-classes-enum
    Structures and Classes in swift !
  • control-system-swift
    Control Flow in Swift
  • swift-concurrency-await
    Concurrency in Swift
  • time-complexity-dsa
    The Term Time Complexity in DSA
  • objective-c-datatypes1
    Objective-C Data Types
  • Convert-jpeg-word
    Convert JPG to Word – Tips You Should Try!
  • objective-c-control-statements2
    Objective-C control statements and loops !

Quick Links

  • #about
  • #myapps
  • #contact
  • #privacy

Other Websites

  • #myQuestions
  • #myBhojanalaya
  • #gadgetFacts
  • #ifscCodesDB

Tag Cloud

Android Android Studio API APP Programming Apps AS400 blogging Browser C# Code Config CSS DATABASE error Features HTML HTML5 IDE installation Interview Questions IOS IOS Features iPhone JAVA javascript Mac objective-c OneDrive OS Programming quicktips SDK SEO Settings SMO SQL swift swiftUI Teams Tips & Tricks Tools UI Web Wordpress Xcode

©mycodetips.com