search for: dbs

trying to structure sql to merge two datasets. structure follows: dbs.possible.combos (all possible combinations of dates and places) Date Place 1/1/10 N-01 1/1/10 S-02 1/2/10 N-01 1/2/10 S-02 etc... dbs.aggregate (the raw data aggregated by date and location) Date Place Days 1/1/10 N-01 6 1/1/10 S-02 10 1/2/10 S-02 5 Trying to merge so I look-up the values for ea...

...urn the value of the factor? By way of example, for Lon=-82.49574 and Lat=29.71495, the code returns state = 1, county = 1 and tract = 161. The desired results are state=12, county = 001 tract = 002201. #set libraries library(UScensus2000tract) library(gdata) data(florida.tract) #read input dbs.in = read.delim("addresses_coded_new.txt", header = TRUE, sep = "\t", quote="\"", dec=".") #instantiate output more.columns <- data.frame( state=double(0), county=double(0),...

Hey all, I've been using ->add_database for a few years to tie sharded DBs together and it works great. Now, I want to be able to search across several DBs which aren't sharded, say: linux-DB, glibc-DB, freebsd-DB. I want to search for something across all of them, but prioritize results to favor one or some of those DBs over others. Is there a way to do that witho...

Folks, OK found it, omega.cc looks for multiple DB definitions and adds it to the search list. If the dbs are only one directory lower (e.g. not in default as in beta/default, but only "beta"), then modifying database_dir setting as follows will work: database_dir /svr/hda1/xapian then, ./omega.cgi 'P=pda' FMT='xml' DB="beta" DB="gamma" DB="delta&qu...

Hello, I have a bunch of data files all with "dbs" file extensions. They are generated via a SQL query from another program and source. Does anyone know (or have ideas) how to get the data from a dbs file type into R (or into some other format that can imported to R)? I've searched online for 4 hours now... Thanks! Ben [[alternative H...

If I try: rsync -lptgoD -e "ssh -i /root/.ssh/rsync-key" --verbose --exclude="/*.*" --exclude="*.xml" --include="+ */Tariff/" 192.168.1.1:/home/e-smith/files/ibays/frogs/files/dbs/ rsync lists the correct files, but if I add the destination like this: rsync -lptgoD -e "ssh -i /root/.ssh/rsync-key" --verbose --exclude="/*.*" --exclude="*.xml" --include="+ */Tariff/" 192.168.1.1:/home/e-smith/files/ibays/frogs/files/dbs/ /home/e-smith/...

On Fri, Feb 07, 2020 at 09:33:08PM +0000, Eric Wong wrote: > Hey all, I've been using ->add_database for a few years > to tie sharded DBs together and it works great. > > Now, I want to be able to search across several DBs > which aren't sharded, say: linux-DB, glibc-DB, freebsd-DB. > > I want to search for something across all of them, but > prioritize results to favor one or some of those DBs over > other...

Olly Betts <olly at survex.com> wrote: > On Fri, Feb 07, 2020 at 09:33:08PM +0000, Eric Wong wrote: > > Hey all, I've been using ->add_database for a few years > > to tie sharded DBs together and it works great. > > > > Now, I want to be able to search across several DBs > > which aren't sharded, say: linux-DB, glibc-DB, freebsd-DB. > > > > I want to search for something across all of them, but > > prioritize results to favor one or som...

Hi I've decided to use xapian because my files table in my mysql database is going to grow very large, and it seems mysql isn't good at full text searching. I'm doing this with the php wrapper by the way. The way my system is set out, each user has their own set of files, and when doing a search it is going to be for a specific user's file (based on file name, title,

Every now and then when I am working on making the SQL Server adapter pass all the ActiveRecord tests, I notice one that looks like a false positive in the core DBs. Here is one case in relations_test.rb. Can someone look at this and just tell me it is normal for other DBs and just odd for SQL Server? Or maybe it is just my understand of some SQL standard. I''m really not that SQL smart. Honestly. def test_count_explicit_columns Post.update_all(...

...it. Basically, we have a product where each customer has their own profile with data stored in a separate database. There are some tables in a common ''system-wide'' database such as the user, role & permission tables, but a lot of other stuff has to be divided up into separate DBs per customer. I realise this isn''t the best way to organise the data but it''s a requirement of the project so i''m stuck with it. I need to be able to tell my model what DB to connect to based on what profile the logged in user has. Something similar to: [code] class Rep...

...ve been once in a while over the years thinking about implementing CalDAV (and CardDAV) to Dovecot. It might be time to start that soon. Does anyone have any suggestions? So far my main goals would be: - scalable, of course - configurable storage (object storage, regular fs, maybe some key-value dbs, maybe storing as emails) - efficient indexes (potentially using key-value dbs? or maybe just local files. not sure yet what kind of indexing is needed) - have it work with dsync (= replication & migration) Some things I wonder about: - Maybe there is already some code out there that could...

Welcome, I'm new one here . I've switch to dovecot in order to get mysql auth to recive emails. And I am not sure about one thing : may I configure dovecot to user more then one DB to authorize users ? I have suse 11.1/postfix/mysql system where the users exist in 2 separate DBs. Delivering works well, I'm just not sure if everyone could revive the emails ? Any tips ? reagards, Sebastian

...iations, and I got sick of seeing all those "SELECT * FROM users WHERE id = 1". I don''t know if those would get cached in production or not, but I didn''t want to mess with it. Since I can assume I''ll keep my global DB on the same server instance as the site DBs, I wound up just using a single connection (for the site DB), and then overriding the table names to include the DB name ("rails"), e.g.: class User < ActiveRecord::Base set_table_name "rails.users" has_and_belongs_to_many :roles, :join_table => "rails....

I''ve dug thru docs, recipes, wiki, but haven''t found anything quite like what I''m trying to do.. I have 2 databases with the same tables and same models representing them. I want to get an item (of same name) from the 2 dbs for comparison. Now, each example of connecting to multiple dbs I''ve seen (including from Rails Recipes and the wiki) assumes that you want different models accessing the different databases. How can I have the same model access 2 different dbs at the same time? I''ve looked...

Fri, 17 Jul 2020 18:23:42 +0100 Rowland penny via samba <samba at lists.samba.org>: > On 17/07/2020 17:59, RhineDevil wrote: > > I mean all dbs containing samba ad-dc data > > Forgot to ask something, an LDAP client connecting to samba LDAP implementation can use `cn=mycn,dc=domain,dc=tld` or it's forced to provide DC and CN in uppercase? > > As far as I am aware, if you have one DC, you would need to totally > remove...

Hi, I'm trying to understand why/how absolute file paths are stored in .rdb[1] and .rds[2] files during package installation. As a consequence building the same r package in different directories does not produce identical .rdb and .rds files. The background is that I work on reproducible builds[3] of R packages. I think this is important from an engineering point of view but also from a

kernel: 2.6.37.6 At least twice I''ve experienced problems when using btrfs with ssd for postgresql db storage. Server gets frozen, i even can''t kill it using kill -9, I cant chown postgresql db dir (it never gets done). If I initiate copy operation of postgresql db dir to another partition (without actually switching to using it) everything starts to work fine for some time...

On Sat, Feb 08, 2020 at 06:04:42PM +0000, Eric Wong wrote: > Olly Betts <olly at survex.com> wrote: > > On Fri, Feb 07, 2020 at 09:33:08PM +0000, Eric Wong wrote: > > > Or would I fiddle with wdf_inc for all ->index_text and ->add_term > > > calls on a per-DB basis? > > > > That would probably work if you don't want to be able to vary the

On Wed, Feb 19, 2020 at 10:23:09AM +0000, Eric Wong wrote: > Btw, is there a way to quickly figure out which sub-DB a retrieved > document or mset item belongs to? Yes: https://trac.xapian.org/wiki/FAQ/MultiDatabaseDocumentID 1.4.12 added a Database::size() method which reports the number of shards - for older versions you have to keep track of that yourself (which needs a little care as