Stack Overflow
Stack Overflow

Questions tagged [zumero]

A cross-platform library and server synchronizing SQL Server databases with SQLite databases on Android, iOS, Xamarin, PhoneGap, Windows, Mac, and Linux. For questions regarding the Zumero DataGrid control, use the [zumero-datagrid] tag instead.

Zumero comprises a cross-platform library and server synchronizing SQL Server databases with SQLite databases on Android, iOS, Xamarin, PhoneGap, Windows, Mac, and Linux.

Zumero handles synchronization, merging, collision resolutions, and efficient delta communications for mobile SQLite databases on a variety of platforms. SQLite operations remain essentially unchanged from local-only code, with an extra function call or two when synchronizing.

SDKs and examples: Zumero Dev Center

36 questions
5
votes
1 answer

Why does zumero_sync need to be called multiple times?

According to the documentation for zumero_sync: If a large amount of information needs to be pulled from the server, this function may need to be called more than once. In my Android app that uses Zumero that's no problem; I just keep calling…
Keith Platfoot
  • 240
  • 1
  • 6
3
votes
2 answers

How to use a DateTime in a where clause in Sqlite.Net

I am writing a mobile application which uses Sqlite.Net I am trying to filter my Table using a DateTime property and LINQ to SQL I have the following piece of code: var validDates = Database.Connection.Table() .Where(x => x.StartDate…
JKennedy
  • 18,150
  • 17
  • 114
  • 198
3
votes
1 answer

How can I optimise Zumero sync queries

I am currently experiencing very long sync times on a zumero synced database (well over a minute), and following some profiling, the culprit appears to be a particular query that is taking 20+ seconds (suitably anonymised): WITH relevant_rvs AS ( …
Stephen James Hand
  • 173
  • 8
3
votes
0 answers

Sync SQL Server with IOS Sqlite

I have the following components SQL Database Server Web Server with web services IOS Device with app written in Xamarin The IOS app talks to the webservices to update SQL Server database. What is the best way (tool) to sync the database? Its a…
user2837961
  • 1,505
  • 3
  • 27
  • 67
3
votes
1 answer

Zumero Xamarin Won't Compile

I am trying to use the Zumero Xamarin component, but I get a compiler error. The type 'System.Data.Common.DbConnection' is defined in an assembly that is not referenced. I included the component to my project and added the following code. using…
Bryan
  • 17,201
  • 24
  • 97
  • 123
2
votes
2 answers

Can I change the server-side schema without changing the Zumero-synched client schema?

If we are going to use Zumero... Does the schema between remote and local need to remain the same, or not? Because if we deploy the application, we won't be able to change the local schema. Environment: Xamarin.Forms in the MAC Machine, SQLite…
user1027076
  • 175
  • 1
  • 4
  • 12
2
votes
1 answer

No such table in ZSS Test Client window

Using the Test Client, I get a "No Such Table" error when trying to select some data from my database - sync was successful. Here's my query: select * from schema.TableName.
iamcelineugat
  • 23
  • 3
2
votes
2 answers

Zumero error 1992: http_404

I've successfully configured ZSS Server on my internal system (Win Server 2008R2 + IIS 7.5), and everything works fine. Now I'm trying to install the same system on a customer machine; I've done this through the installer (latest version), he has…
user3585192
  • 33
  • 4
2
votes
1 answer

Is timestamp-driven conflict resolution possible?

According to the Zumero for SQL Server documentation the default conflict resolution behaviour is to use a record version number. However, is it possible to base it on timestamps instead? The business rule is that the record that was last updated…
user2935274
  • 51
  • 5
2
votes
1 answer

How to call zumero_internal_auth_add_user from Android client

I'm updating my Android app to use Zumero to handle data sync. Each user will get their own dbfile on the server, as well as their own internal auth account. However, I can't get zumero_internal_auth_add_user to work in Android. I invoke the…
Keith Platfoot
  • 240
  • 1
  • 6
2
votes
1 answer

Exception when calling zumero_sync

Having an issue getting started with syncing sqllite db with zumero (using xamarin.ios). I have setup my sync command : cmd.CommandText = @"SELECT zumero_sync( 'main', @server_url, @dbfile, …
user2420225
  • 97
  • 2
  • 10
1
vote
0 answers

How can I merge a record on sync using Zumero rather than adding it?

I show my users a list of items to choose from and they pick an item to work with. If the store is disconnected, the item they need might not be there, so I offer the ability to enter an identifier of the item and then create a new local, object for…
Joshua Frank
  • 13,120
  • 11
  • 46
  • 95
1
vote
0 answers

Xamarin Mobile offline DB sync with SQL Server on-premise

Is there a way to sync a SQLite mobile offline DB with an on premise SQL Server? As far as I understand, Azure offline sync syncs with Table storage and not SQL server. Also, hybrid connection and hybrid connection manager doesn't take care of…
Joseph Kallarackal
  • 11
  • 3
1
vote
2 answers

"Table already exists" error using Zumero sync in a Xamarin.Forms application

When I run the app in the Xamarin Android player it works just fine, but when I run on a device I am getting the following error: Error 1 (sqlite): CREATE TABLE main."custScanned" ( z_rv INTEGER NULL UNIQUE REFERENCES "z$rv$1483152329"(z_rv)…
RdDragon
  • 67
  • 6
1
vote
1 answer

Zumero server with HTTPS: are wildcard certificates valid?

We are migrating our Zumero service in order to use HTTPS. In the server installation doc, it says that an SSL certificate for the fully qualified domain name (FQDN) is required. My question is: Can we use a wildcard certificate instead of an FQDN…
pozuelog
  • 1,284
  • 13
  • 27
1
2 3