Categories
Database Development

Update query with where clause taking time on clustered index with millions of data

CREATE TABLE Test_Table ( Id INT NOT NULL, Column2 VARCHAR(64) NOT NULL, Column3 VARCHAR(10) NOT NULL, Column4 VARCHAR(64) NOT NULL, Column5 VARCHAR(10) NOT NULL, Column6 VARCHAR(256) NOT NULL, Column7 INT NOT NULL, Column8 VARCHAR(10) NOT NULL, column9 INT NOT NULL, Column10 DATETIME NULL, Flag BIT NULL ) CREATE UNIQUE CLUSTERED INDEX PK_Test_Table ON Test_Table ( […]

Categories
Ask Geographic Information System (GIS)

Create point geometry in PostGIS from a X Y Z M coordinate format

I would like to get a PostGIS point table from a PostGreSQL table containing OpenDataKit data where the coordinates are contained into in a column in a X Y Z M format (M being I think the value of the GPS precision in meters). E.g: 10.384643333333335 -23.214940000000002 -0.8 5.0 My first question is: what should […]

Categories
Ask Geographic Information System (GIS)

Create point geometry in PostGIS from a X Y Z M coordinate format

I would like to get a PostGIS point table from a PostGreSQL table containing OpenDataKit data where the coordinates are contained into in a column in a X Y Z M format (M being I think the value of the GPS precision in meters). E.g: 10.384643333333335 -23.214940000000002 -0.8 5.0 My first question is: what should […]

Categories
Ask Geographic Information System (GIS)

Create point geometry in PostGIS from a X Y Z M coordinate format

I would like to get a PostGIS point table from a PostGreSQL table containing OpenDataKit data where the coordinates are contained into in a column in a X Y Z M format (M being I think the value of the GPS precision in meters). E.g: 10.384643333333335 -23.214940000000002 -0.8 5.0 My first question is: what should […]

Categories
Mastering Development

custom percentile to display in dynamic context after boxplot (shiny)

I am looking to display tables with percentile like as filters to identify extreme datas. My final aim is to display in my DB (shiny) each tab in different tabPanel. My issue is how get percentile value in a dynamic context and to re use it like as filter in a dataTable. I tried a […]

Categories
Mastering Development

Python numpy groupby multiple columns

Is there a way to make a group by aggregation by multiple columns in numpy? Im trying to do it with this module: https://github.com/ml31415/numpy-groupies Goal is to get a faster groupby than pandas. for example: group_idx = np.array([ np.array([4, 3, 3, 4, 4, 1, 1, 1, 7, 8, 7, 4, 3, 3, 1, 1]), np.array([4, […]

Categories
Mastering Development

Behaviour of DateEntry in Tkinter Window

I have a button that adds a DateEntry widget to a scrollable frame. Unfortunately, the frame is at the bottom of the window, so after adding a few rows, the dropdown calendar hides behind the task bar. Is there any way to change it, so the calendar opens above the field, rather than below? Here […]

Categories
Mastering Development

bulk insert into sql server using package database/sql package

I am trying to insert multiple records in sql server using Go. I am using below code. but getting this error "mssql: Incorrect syntax near ‘?’." . func BulkInsert(unsavedRows []*ExampleRowStruct) error { valueStrings := make([]string, 0, len(unsavedRows)) valueArgs := make([]interface{}, 0, len(unsavedRows) * 3) for _, post := range unsavedRows { valueStrings = append(valueStrings, "(?, […]

Categories
Mastering Development

Tkinter, design is messed up and i can’t make it look good

Im trying to make a simple gui for a tool that im using to send sms text messages, but the placement of entries and labels is not correct. It feels wonky and weird: For some reason the text fields are just messed up and the input for the message text field is just a mess. […]

Categories
Mastering Development

arrays into pandas dataframe columns

I have a program that outputs arrays. For example: [[0, 1, 0], [0, 0, 0], [1, 3, 3], [2, 4, 4]] I would like to turn these arrays into a dataframe using pandas. However, when I do the values become row values like this: As you can see each array within the overall array becomes […]