Creating an sqlite db outside of B4A

Ricky D · Jan 25, 2012

What tools are available to create sqlite databases I can put in my app?

I've tried creating one from the firefox sqlite manager add on but B4A wouldn't read it.

Any ideas?

regards, Ricky

NJDude · Jan 25, 2012

You can try SQLite Studio

Ricky D · Jan 25, 2012

have you used it?

I am wondering if it works with b4a?

regards, Ricky

NJDude · Jan 25, 2012

Yes, I use it all the time, I create a DB and then add it to my B4A project.

Ricky D · Jan 25, 2012

Key field though?

I can't set a field to be the key for the table

How do you do that?

regards, Ricky

NJDude · Jan 25, 2012

Click on "Create Index" on the icon menu.

If that app is not of your liking, you could try SQLiteExpert is not free but it has a trial version and way better than SQLite Studio.

Ricky D · Jan 25, 2012

I can't afford to buy more software so this will have to do

but how do I create the field manually and what format would it be?

regards, Ricky

NJDude · Jan 25, 2012

If you create a DB from scratch, you will see all the settings available, is not difficult.

Inman · Jan 25, 2012

I use SQLite Database Browser to create db on Windows and then bundle it with the Android apps. The database it creates is 100% compatible with B4A. You can create tables and add data manually or you can import from CSV files as well. It also has an option to test SQL queries and see the data that gets returned which is convenient as you can fine tune the queries and use it on B4A instead of doing trial and error on B4A itself.

And the best part - it is free

NJDude · Jan 25, 2012

Inman, the version you posted is the "old" version of SQLiteStudio.

Ricky D · Jan 25, 2012

ok...

Back to my original problem.

It doesn't have boolean.

How do you handle booleans in android sqlite?

:BangHead:

regards, Ricky

Inman · Jan 25, 2012

NJDude said:
Inman, the version you posted is the "old" version of SQLiteStudio.

Really? Never knew it. I downloaded it 2 years back for another project and never had to look for another app (or even an update) as it fit all my needs.

NJDude · Jan 25, 2012

Ricky D said:
Back to my original problem.

It doesn't have boolean.

How do you handle booleans in android sqlite?

:BangHead:

regards, Ricky

Look at the screen shot, you have to click on the [...] button and then enter the data type.

Ricky D · Jan 25, 2012

Even setting the type to boolean didn't work

I created a simple table :

Shifts
TableID Int Primary Key Not Null
IsLocked boolean

then when I run this sql in the Execute Sql pane on sql studio

Insert Into Shifts (TableID,IsLocked) Values (1,true)

it threw an error

changing it to

Insert Into Shifts (TableID,IsLocked) Values (1,1)

worked

So I'll store them as Int with false=0 and true=1

cheers, Ricky

Kiffi · Jan 25, 2012

my favourite is TkSQLite.

Greetings ... Kiffi

warwound · Jan 25, 2012

Ricky D said:
I created a simple table :

Shifts
TableID Int Primary Key Not Null
IsLocked boolean

then when I run this sql in the Execute Sql pane on sql studio

Insert Into Shifts (TableID,IsLocked) Values (1,true)

it threw an error

changing it to

Insert Into Shifts (TableID,IsLocked) Values (1,1)

worked

So I'll store them as Int with false=0 and true=1

cheers, Ricky

That behaviour sounds like the way MySQL handles Boolean data type.

MySQL does in theory have a Boolean data type but:

These types are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true

That's a quote from MySQL :: MySQL 5.0 Reference Manual :: 10.1.1 Numeric Type Overview.

Use an Integer data type in SQLite and you'll have no problems.

Martin.

Ricky D · Jan 25, 2012

that's it

:icon_clap:

Thanks for showing me that. I've implemented it as ints and is working just fine.

cheers, Ricky

stefanoa · Jan 25, 2012

SQLite Expert Personal (freeware)
SQLite Expert - A powerful administration tool for your SQLite databases

mjtaryan · Sep 23, 2012

Ricky D said:
Back to my original problem.

It doesn't have boolean.

How do you handle booleans in android sqlite?

:BangHead:

regards, Ricky

I don't know whether you got an answer to your question, but I was just reading some SQLite documentation and came across just the info you need.

SQLite, first of all, does not employ datatypes in the more common fashion. And second, with reference to your question, implements Boolean as an integer with 0 = False and 1 = True. For more details go to SQLite.org and search for "Boolean". Hope this helps.

alienhunter · Sep 23, 2012

I am using this one
:sign0163:
works like a charm ...for everything

WampServer,
a Windows web development environment.

WampServer is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MySQL database. Alongside, PhpMyAdmin allows you to manage easily your databases.

WampServer, the web development platform on Windows - Apache, MySQL, PHP

Creating an sqlite db outside of B4A

Well-Known Member

Expert

Well-Known Member

Expert

Well-Known Member

Expert

Well-Known Member

Expert

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Expert

Attachments

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Active Member

Active Member

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency