Need help with firebirdsql?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

nakagami
157 Stars 46 Forks MIT License 656 Commits 13 Opened issues

Description

Firebird RDBMS sql driver for Go (golang)

Services available

!
?

Need anything else?

Contributors list

firebirdsql (Go firebird sql driver)

Firebird RDBMS https://firebirdsql.org SQL driver for Go

Requirements

  • Firebird 2.5 or higher
  • Golang 1.15 or higher

Example

package main

import ( "fmt" "database/sql" _ "github.com/nakagami/firebirdsql" )

func main() { var n int conn, _ := sql.Open("firebirdsql", "user:[email protected]/foo/bar.fdb") defer conn.Close() conn.QueryRow("SELECT Count(*) FROM rdb$relations").Scan(&n) fmt.Println("Relations count=", n)

}

See also driver_test.go

   package main

  import (
   "fmt"
   "github.com/nakagami/firebirdsql"

)

func main() { dsn := "user:[email protected]/foo/bar.fdb" events := []string{"my_event", "order_created"} fbEvent, _ := firebirdsql.NewFBEvent(dsn) defer fbEvent.Close() sbr, _ := fbEvent.Subscribe(events, func(event firebirdsql.Event) { //or use SubscribeChan fmt.Printf("event: %s, count: %d, id: %d, remote id:%d \n", event.Name, event.Count, event.ID, event.RemoteID) }) defer sbr.Unsubscribe() go func() { fbEvent.PostEvent(events[0]) fbEvent.PostEvent(events[1]) }()

See also _example

Connection string

user:[email protected][:port_number]/database_name_or_file[?params1=value1[&param2=value2]...]

General

  • user: login user
  • password: login password
  • servername: Firebird server's host name or IP address.
  • port_number: Port number. default value is 3050.
  • databasenameor_file: Database path (or alias name).

Optional

param1, param2... are

| Name | Description | Default | Note | | --- | --- | --- | --- | | authpluginname | Authentication plugin name. | Srp | Srp256/Srp/LegacyAuth are available. | | columnnametolower | Force column name to lower | false | For "github.com/jmoiron/sqlx" | | role | Role name | | | | timezone | Time Zone name | | For Firebird 4.0+ | | wire_crypt | Enable wire data encryption or not. | true | For Firebird 3.0+ | | charset | Firebird Charecter Set | | |

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.