Skip to navigation Skip to content
Simon Technology Blog
  • Architecture
  • Cloud
  • Database
  • Develop
  • Hardware
  • Industry
  • Language
  • Mobile
  • Opensource
  • OS
  • Web
Main Navigation

Author: Simo

35 application scenarios in the NOSQL database

【Sumeng is committed to becoming the most outstanding data science community, focusing on big data, analysis and mining, and data visualization Field, business scope: offline activities, online cou

September 21, 2021By Simo Nosql application, database, NOSQL, sceneLeave a Comment

Looking for the build forest (with recursive, postgreSQL 9.5)

I have a table of identities (ie aliases) for any number of people. Each row has a previous name and a new name. In production, there are approximately 1M rows. For example:

id, old, new
—

September 21, 2021By Simo Postgresql 9.5, build, forest, Looking for, PostgreSQL, RecursiveLeave a Comment

PostgreSQL – Columns must appear in Group BY clauses or for polymeric functions

I am updating the Qt software to make it compatible with SQLite and PostgreSQL.
I have a C method for calculating the elements of a given table of a given sub-sentence. < /p> In SQLite, the follow

September 21, 2021By Simo Postgresql appear, clause, Column, Group, Medium, must, PostgreSQL, UsedLeave a Comment

TIDB source reading series articles (1)

At TiDB DevCon2018, we announced the TiDB source code reading and sharing activity, and promised to publish a series of articles and videos to help everyone understand the TiDB source code. Everyon

September 21, 2021By Simo Nosql article, one, order, reading, series, Source Code, TIDBLeave a Comment

PostgreSQL – Postgres Query Optimization

Below are two almost identical postgres queries, but produced very different query plans and execution times. I assume that the first query is fast because form_id =’W40′ is only 196 Form_instance

September 21, 2021By Simo Postgresql Optimization, Postgres, PostgreSQL, problem, queryLeave a Comment

PostgreSQL – Reset ID count after table deletion ()

For testing purposes, I clear (delete) each table before executing the code.

for table in reversed (db.metadata.sorted_tables):
engine.execute(table.delete())
do_stuff() However, the id valu

September 21, 2021By Simo Postgresql Count, delete, ID, PostgreSQL, reset, tableLeave a Comment

NOSQL – Cassandra column key automatically increment

I am trying to understand Cassandra and how to build my column family (CF), but since I am used to relational databases, it is difficult.

For example , If I create a simple user CF and I try

September 21, 2021By Simo Nosql Auto, Cassandra, Column, Increment, key, NOSQLLeave a Comment

Running errors in PostgreSQL

CREATE OR REPLACE FUNCTION msgfailerror() RETURNS trigger AS
‘ BEGIN
IF NEW.noces< new.first_column THEN RAISE EXCEPTION ' cannot have a negative salary'; END IF; return new; END' LANGUAG

September 21, 2021By Simo Postgresql error, middle, PostgreSQL, triggerLeave a Comment

PostgreSQL – PLPGSQL function returns another function value

I have a function func1() that returns integers.

I want to write another function func2 (mode integer), which can return func1()reults Or do more things. The return value of func1() is INTEGE

September 21, 2021By Simo Postgresql Another, function, PLPGSQL, PostgreSQL, returnLeave a Comment

Add a missing monthly date in the time series data in PostgreSQL

I have monthly time series data in the table, where the date is the last day of the month. Some dates are missing in the data. I want to insert these dates and add zero values ​​for other attribute

September 21, 2021By Simo Postgresql addition, data, Date, Medium, missing, monthly, PostgreSQL, Time SeriesLeave a Comment

Posts navigation

Page 1 … Page 545 Page 546 Page 547 … Page 590
Recent Posts
  • Sencha-Touch-2 – Sencha Touch 2, Nested XML Analysis NodeValue
  • Add a separation line and format XML content
  • Is there a norm of simplified XML subsets?
  • Look at it when you write React
  • ReactJS – Present React Redux React-Router App to add the server to the Firebase hosted by the Firebase
Categories
  • Android
  • Apache
  • Apache Kafka
  • Asp
  • Auto-Test
  • Automated Build
  • Aws
  • Bitcoin
  • Browser
  • C & C++
  • C#
  • Centos
  • Cgi
  • Character
  • Cloud Service
  • Cocos2dx
  • Cordova
  • CSS
  • Data Structure
  • Delphi
  • Design Pattern
  • Dojo
  • Dubbo
  • ELK
  • Flex
  • football
  • Game
  • Hadoop
  • Hibernate
  • HTML
  • Hybrid
  • Intel
  • IOS
  • Ipad
  • iPhone
  • Java
  • Javascript
  • Jetty
  • JQuery
  • Jsp
  • Linux
  • Load Balance
  • Lua
  • Macbook
  • Macos
  • Mathematics
  • Micro Services
  • Monitoring
  • Motherboard
  • Mysql
  • Network Hardware
  • Network Marketing
  • Nginx
  • NodeJs
  • Nosql
  • Oracle
  • Os Theory
  • Performance
  • PHP
  • Postgresql
  • Power Designer
  • React
  • Redis
  • Regexp
  • Rom
  • Rss
  • Ruby
  • Search Engines
  • Shell Script
  • Silicon Valley
  • Silverlight
  • Software Design
  • Spring
  • Sql
  • Sqlite
  • Sqlserver
  • Storage
  • Storm
  • Surface
  • SVN
  • Swift
  • System Architecture
  • Tablet
  • Uncategorized
  • Unix
  • Visual Basic
  • Visual Studio
  • Web Crawler
  • WebService
  • Windows
  • Wireless
  • XML
  • ZooKeeper
Archives
  • October 2021
  • September 2021
  • August 2021
  • May 2021
  • April 2021
  • September 2020
  • September 2019
  • August 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
© Simon Technology Blog 2025 • ThemeCountry Powered by WordPress