# Firebird database in Julia?

**URL:** https://discourse.julialang.org/t/firebird-database-in-julia/33295
**Category:** New to Julia
**Tags:** database
**Created:** [January 13, 2020, 8:56am UTC](https://discourse.julialang.org/t/firebird-database-in-julia/33295 "2020-01-13T08:56:01Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Darione](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/darione/32/12160_2.png) [@Darione](https://discourse.julialang.org/u/Darione)
#### Post date: [January 13, 2020, 8:56am UTC](https://discourse.julialang.org/t/firebird-database-in-julia/33295/1 "2020-01-13T08:56:01Z")

</div>

Hello,  
we use Firebird database in our compnay, for our Erp software.  
I was trying to use a firebird driver for Julia, and i found this:

> **[GitHub - HatsuneMiku/FirebirdDB.jl: FirebirdDB.jl](https://github.com/HatsuneMiku/FirebirdDB.jl)**
>
> FirebirdDB.jl. Contribute to HatsuneMiku/FirebirdDB.jl development by creating an account on GitHub.

But I, who am a beginner, cannot import the package …  
I have this error … (i am, gibing pwd(), in the folder where i have FirebirdDB.jl")

julia\> import Pkg

julia\> Pkg.add(“FirebirdDB”)  
ERROR: The following package names could not be resolved:

- FirebirdDB (not found in project, manifest or registry)  
Please specify by known `name=uuid`.  
Stacktrace:  
[1] pkgerror(::String) at C:\Users\dario\AppData\Local\Julia-1.3.0\share\julia\stdlib\v1.3\Pkg\src\Types.jl:113  
[2] #ensure\_resolved#101(::Bool, ::typeof(Pkg.Types.ensure\_resolved), ::Pkg.Types.EnvCache, ::Array{Pkg.Types.PackageSpec,1}) at C:\Users\dario\AppData\Local\Julia-1.3.0\share\julia\stdlib\v1.3\Pkg\src\Types.jl:936  
[3] #ensure\_resolved at .\none:0 [inlined]  
[4] #add#25(::Bool, ::Pkg.BinaryPlatforms.Windows, ::Base.Iterators.Pairs{Union{},Union{},Tuple{},NamedTuple{(),Tuple{}}}, ::typeof(Pkg.API.add), ::Pkg.Types.Context, ::Array{Pkg.Types.PackageSpec,1}) at C:\Users\dario\AppData\Local\Julia-1.3.0\share\julia\stdlib\v1.3\Pkg\src\API.jl:97  
[5] add(::Pkg.Types.Context, ::Array{Pkg.Types.PackageSpec,1}) at C:\Users\dario\AppData\Local\Julia-1.3.0\share\julia\stdlib\v1.3\Pkg\src\API.jl:72  
[6] #add#24 at C:\Users\dario\AppData\Local\Julia-1.3.0\share\julia\stdlib\v1.3\Pkg\src\API.jl:69 [inlined]  
[7] add at C:\Users\dario\AppData\Local\Julia-1.3.0\share\julia\stdlib\v1.3\Pkg\src\API.jl:69 [inlined]  
[8] #add#21 at C:\Users\dario\AppData\Local\Julia-1.3.0\share\julia\stdlib\v1.3\Pkg\src\API.jl:67 [inlined]  
[9] add at C:\Users\dario\AppData\Local\Julia-1.3.0\share\julia\stdlib\v1.3\Pkg\src\API.jl:67 [inlined]  
[10] #add#20(::Base.Iterators.Pairs{Union{},Union{},Tuple{},NamedTuple{(),Tuple{}}}, ::typeof(Pkg.API.add), ::String) at C:\Users\dario\AppData\Local\Julia-1.3.0\share\julia\stdlib\v1.3\Pkg\src\API.jl:66  
[11] add(::String) at C:\Users\dario\AppData\Local\Julia-1.3.0\share\julia\stdlib\v1.3\Pkg\src\API.jl:66  
[12] top-level scope at none:0

What i can do having cloned the source code on my pc, to import it?

To get Julia in the “weapons” of our company,  
I should be able to access the firebird database …

Many thanks!

---

<div class="post-metadata">

### Author: ![kdyrhage](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/kdyrhage/32/2326_2.png) [@kdyrhage](https://discourse.julialang.org/u/kdyrhage)
#### Post date: [January 13, 2020, 9:04am UTC](https://discourse.julialang.org/t/firebird-database-in-julia/33295/2 "2020-01-13T09:04:04Z")

</div>

The package is unregistered. Try

```julia
]add https://github.com/HatsuneMiku/FirebirdDB.jl.git

```

---

<div class="post-metadata">

### Author: ![avik](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/avik/32/17_2.png) [@avik](https://discourse.julialang.org/u/avik)
#### Post date: [January 13, 2020, 8:37pm UTC](https://discourse.julialang.org/t/firebird-database-in-julia/33295/3 "2020-01-13T20:37:48Z")

</div>

Note that the FirebirdDB.jl code is pretty old, and is unlikely to work as-is on Julia 1.x. It also seems to be pretty basic (and probably incomplete) (sorry, just setting your expectations here).

---

<div class="post-metadata">

### Author: ![ExpandingMan](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/expandingman/32/866_2.png) [@ExpandingMan](https://discourse.julialang.org/u/ExpandingMan)
#### Post date: [January 13, 2020, 8:51pm UTC](https://discourse.julialang.org/t/firebird-database-in-julia/33295/4 "2020-01-13T20:51:51Z")

</div>

Note that the ultimate fall-back for database support in Julia is [JDBC.jl](https://github.com/JuliaDatabases/JDBC.jl). If you can’t access a database directly in Julia because native Julia software or a C wrapper doesn’t exist, in almost all cases a driver exists for JDBC. Unfortunately this comes at the price of adding the JVM as a dependency, but at least you can be fairly confident that you’ll never be stuck without a way to access your database from inside Julia.

---

<div class="post-metadata">

### Author: ![Darione](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/darione/32/12160_2.png) [@Darione](https://discourse.julialang.org/u/Darione)
#### Post date: [January 14, 2020, 8:14am UTC](https://discourse.julialang.org/t/firebird-database-in-julia/33295/5 "2020-01-14T08:14:30Z")

</div>

Thanks @avik, in fact I have imported correctly the package (thanks to @kdyrhage), but then it makes mistakes in compiling it, so i think you are right …

At least, I seem to have understood, what can I do in the way suggested by @kdyrhage if I run into a package that Julia doesn’t care directly, right?

---

<div class="post-metadata">

### Author: ![Darione](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/darione/32/12160_2.png) [@Darione](https://discourse.julialang.org/u/Darione)
#### Post date: [January 14, 2020, 8:24am UTC](https://discourse.julialang.org/t/firebird-database-in-julia/33295/6 "2020-01-14T08:24:48Z")

</div>

Ah, many thanks @ExpandingMan !

I have seen in the Firebird web site that it has driver for ODBC e JDBC:

> **[Firebird: The true open source database for Windows, Linux, Mac OS X and more](https://firebirdsql.org/en/drivers-documentation/)**
>
> Firebird SQL: The true open-source relational database

Honestly, I don’t know Java very well … i think to use ODBC instead …

So the way to use our database is this one, ok … i will test …

---

<div class="post-metadata">

### Author: ![nakagami](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nakagami/32/28759_2.png) [@nakagami](https://discourse.julialang.org/u/nakagami)
#### Post date: [October 2, 2021, 12:40pm UTC](https://discourse.julialang.org/t/firebird-database-in-julia/33295/7 "2021-10-02T12:40:42Z")

</div>

I recently regretted juliahub the Firebird driver.  
[https://juliahub.com/ui/Packages/Firebird/pPw8v/0.2.0](https://juliahub.com/ui/Packages/Firebird/pPw8v/0.2.0)  
Try it!
