Questions tagged [dbaccess]

DBAccess is a freely distributed ORM for use on iOS & MacOS X, created by iPresent inc.

About DBAccess

DBAccess is a FREE to use and distribute ORM for iOS / Objective-c with speed, power and developers in mind!

What makes DBAccess so special?

  • It is hugely thread-safe, as a developer you don't want to have to create superfluous code just to ensure that all queries and actions are performed on a common thread. You just want to write tidy and efficient code that is easy to understand.
  • It is fast!, we give you lots of stats to help you fine tune the performance of queries.
  • It has a KILLER event model which enables you to bind data objects to your UI controls and keep them updated with changes made in the database. This alone makes coding an app that is reliant on a database much easier. Event models exist for both individual, entire class and global objects, which makes synchronising your data with other services exceptionally easy.
  • Developers should actively want to use it over the alternatives, through predicable methodology, clear implementations and speed of integration.

About DBAccess

DBAccess is the creation of iPresent employee and lead Objective-C developer, Adrian Herridge. For several years Adrian has worked hard to implement an ORM that speeds up development of applications that utilise SQLite, whilst making common place development activities as simple and seamless as possible.

DBAccess is designed to be a high performance ORM that is easy for developers to use and implement, but also feature packed. We found many ORM's out there already in existence, but most of them were little more than a thin wrapper around SQLite, and were missing many, many, features that were needed within the team.

What is unusual about DBAccess is the architecture of the "core", which allows for detailed performance tuning of your application as well as novel ways to interact with the database to make synchronising data across the UI child's play.

Why distribute all the hard work for nothing ?

iPresent inc, believes that it is important to give back to the community that has made it such a success. Over the past year iPresent has seen explosive growth and success, this in part is due to the creative team that develop not only the platform itself, but also the tools that our developers use to perform their duties day in and day out.

In the course of our development we have used many open resources, and have utilised the immense and helpful iOS development community. From invaluable tools such as stackoverflow.com, to meeting and talking with vastly experienced coders at community events such as WWDC.

It is for these reasons that iPresent would like to give back something we believe will be helpful to other developers in the community.

Downloads, Help & Documentation

Can be found at the projects homepage, http://db-access.org/

66 questions
4
votes
1 answer

Can I use dbaccess for existing sqlite database?

my question is how can I use dbaccess framework with existing sqlite database? I have "test.sqlite" file in my device's Documents folder. I even renamed it to "test.db". When I try to commit the object of my class Worker nothing happens (I don't get…
Marina
  • 1,177
  • 4
  • 14
  • 27
3
votes
1 answer

Relating two objects in DBAccess

I'm using dbaccess for my iOS project. How can I pass an array to dbaccess object? For example: I have dbobject like: @interface Member : DBObject @property (strong) NSString* firstname; @property (strong) NSString* lastName; @end @interface Group…
Dhvl B. Golakiya
  • 239
  • 1
  • 3
  • 10
3
votes
1 answer

How to get previous executed sql in informix

On my esql program when an sql fails and generates the exception I want to print the SQL that generated the exception. For that I need to find out how to get the previously executed SQL. I am running informix 11.5. I tried the following but nothing…
Ramanan T
  • 179
  • 1
  • 10
2
votes
1 answer

How to update Multiple record with specific fields of dbAccess in swift

I want to update multiple record (DBAccess ORM). by condition with specific fields. Like set city = "Goa" where name = "atul". Please review following swift code, it working fine. But how to do this by single query without using for loop. func…
AtulParmar
  • 4,358
  • 1
  • 24
  • 45
2
votes
2 answers

DBAccess linker warnings & errors using Xcode 7 and cocoapods

I've been successfully using DBAccess as a cocoapod in my project for several months. A lot of changes have taken place in my tool chain in the last few weeks and now my build is failing. pod install indicates it installed DBAccess (1.6.9). Xcode…
Jack Jones
  • 23
  • 3
2
votes
1 answer

What does this log mean in dbaccess(framework for ios) "error >> no such table: _entityRevision"?

I use DBAccess in my project as ORM for my sqlite database. I have few models such as User, Worker etc. When I perform some actions with instances of these classes, for example: var query = User.query().whereWithFormat("login = %@ and password …
Marina
  • 1,177
  • 4
  • 14
  • 27
2
votes
1 answer

DBAccess: Get array of any one property value

I have dbobject like: #import #import @interface GroupMember : DBObject @property (strong) NSString *firstname; @property (strong) NSString *lastname; @property (strong) NSString *_id; @end How can…
Dhvl B. Golakiya
  • 239
  • 1
  • 3
  • 10
2
votes
3 answers

Informix: How to get the table contents and column names using dbaccess?

Supposing I have: an Informix database named "my_database" a table named "my_table" with the columns "col_1", "col_2" and "col_3": I can extract the contents of the table by creating a my_table.sql script like: unload to "my_table.txt" select *…
ivo
  • 4,101
  • 5
  • 33
  • 42
2
votes
1 answer

DBAccess creating custom DBAccessSettings

I am testing DBAccess in order to see if I can use it in a project. I have problems changing the location of the sqlite file, I want it to be in cache directory. Here is part of the code I wrote until now, in AppDelegate.m : -…
Horatiu
  • 151
  • 2
  • 12
2
votes
1 answer

How to represent spaces in Perl's DBI properly

I have a record in an Informix table. The table columns look like this: acct_no integer, suffix char(1), meter_num char(20), date_read datetime year to second not null , counter smallint, reading integer not null , typeofread char(1), estimated…
octopusgrabbus
  • 10,555
  • 15
  • 68
  • 131
1
vote
1 answer

How to skip existing records when importing data into a table with an Informix database

I use an Informix database. I access the data of a table via the tool "dbaccess". I have currently saved data from a table via UNLOAD command to a CSV file. I want to import the data into the integration environment into a table. However, some…
1
vote
0 answers

Informix SQL 11.5 storing multiple query results in one file

When I try to save the result of several queries in a file with an unload command in Dbaccess environment , only the first one is saved, and if I use unload several times -one time per query-, only the last query result is saved. unload to…
MD128
  • 501
  • 4
  • 12
1
vote
1 answer

Delete / backspace within dbaccess will not delete characters

Using dbaccess via SSH into a fedora server. When I go to Query - New, both backspace and delete do not have an effect. How can I set up the environment to work with delete/backspace? They work fine in vi. Edit: Some more info. CTRL-H in vi…
psx
  • 4,040
  • 6
  • 30
  • 59
1
vote
1 answer

How to know what causes constraint failure during inserting enrties to a table using a DAT file?

I'm inserting multiple entries to a table using a DAT file. How will I know what records are causing constraint failures (eg. duplicate constraint)? I'm using informix dbaccess to load the entries. Here is a sample code of how I load it: load from…
ligero50
  • 35
  • 1
  • 4
1
vote
0 answers

How to read BLOB with SharkORM

I would like to read a BLOB field from an SQLite database with SharkORM but I don't know how to properly do it. Here is the model I use: class Entries: SRKObject { @objc dynamic var _id = 0 @objc dynamic var meaning = "" @objc dynamic var path:…
Shibakaneki
  • 213
  • 3
  • 12
1
2 3 4 5