# SQLite/DBInterface confusion

**URL:** <https://discourse.julialang.org/t/sqlite-dbinterface-confusion/38458>\
**Category:** General Usage\
**Created:** [April 30, 2020, 12:16am UTC](https://discourse.julialang.org/t/sqlite-dbinterface-confusion/38458 "2020-04-30T00:16:32Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![pixel27](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pixel27/32/8902_2.png) [@pixel27](https://discourse.julialang.org/u/pixel27)\
**Post date:** [April 30, 2020, 11:21am UTC](https://discourse.julialang.org/t/sqlite-dbinterface-confusion/38458/5 "2020-04-30T11:21:51Z")

</div>

You could try:

```julia
dump(SQLite.execute(db,"select * from Test1"))

```

That will show you the object. My guess is they implemented a `show` method for whatever that method returns…and it’s not showing much. Again looking at the code maybe try:

```julia
a = SQLite.execute(db,"select * from Test1")
getvalue(a, 1, Int)

```

Not sure if getvalue() should be prefixed with SQLite.

---

_[View the full topic](https://discourse.julialang.org/t/sqlite-dbinterface-confusion/38458)._