Someone from the backend development side, please help with the below. we have a site driven by Postgres. We also have a elastic search implementation to make f
I have a data frame with a date time index where index values are non unique (see last two index values). I would like to get the next valid index value given a
I have an array of 30 columns and 800 rows (Sheet 1), each cell has either text or is blank. I want to check if ANY values in this array (specificially row by r
How could I (in Python 3) find the index of the second occurrence of a phrase in a string? My code so far is result = string.index("phrase im looking for"
I need to display directory contents on GH Pages. Would prefer Automatically, without index.html A tool or library for automatically generating the index.htm
(I'm running ServiceStack OrmLite 5.1.1) I happen to have a few objects that has a long name, and creating the table as it is setup now creates a table with a l
Could you help me solve the following? I want to return the total sum, not the first match that it finds. My first preference is have indexing and matching wi
Could you help me solve the following? I want to return the total sum, not the first match that it finds. My first preference is have indexing and matching wi
I have a large collection (~20M records) with some moderate documents with ~20 indexed fields. All of those indexes are single field. This collection also has q
I have a table with 60 boolean (TINYINT(1)) searcheable columns. User has possibility of using any subset of the given columns as search condition. Based on tha
I am trying to output the names and corresponding scores in descending order. Having an array of strings and another array of integers, I am trying to relate th
I have solrj client with infinite timeout(Solr4) server.server.setSoTimeout(0) server.server.setConnectionTimeout(0) When I index my data I have many timeou
We all know arrays in Bash are indexed from zero, and in zsh are indexed from one. How can the script know it should use 0 or 1 if I can't ensure the running en
We all know arrays in Bash are indexed from zero, and in zsh are indexed from one. How can the script know it should use 0 or 1 if I can't ensure the running en
I got some non-clustered indexes (unique) with uniqueidentifier (GUID) as column. The index gets a lot of fragmentation all the time. How should I solve this
I have a DataFrame that looks like Emp1 Empl2 date Company 0 0 0 2012-05-01 apple 1 0 1 2012-05-29
I have an error when running the the queries below on PostgreSQL from a Java code ..... sql = "CREATE TABLE IF NOT EXISTS table1 (s VARCHAR(100), p VARCHAR(
How do I split a list into sub-lists based on index ranges? e.g. original list: list1 = [x,y,z,a,b,c,d,e,f,g] using index ranges 0–4: list1a = [x,y,z,a,b
I'm wondering how sorting with an index actually works in MongoDB. There are a couple articles in the MongoDB documentation, but they don't actually describe ho