All Questions

Tagged with
Filter by
Sorted by
Tagged with
34 votes
6 answers
29k views

How do I install/update to Postgres 9.4?

I just installeed Postgres, but it seems to have installed 9.3 and I'd like to start with 9.4 I simply did apt-get install postgresql from a new Ubuntu 14.04.1 machine. http://www.postgresql.org/...
speg's user avatar
  • 2,009
17 votes
9 answers
2k views

What is the best approach to upload 1000+ records to a server that also contains images for each record from an iOS/Android app?

I have a app working offline. It is assumed that 1000+ records are created with images in each record during this period and whenever connectivity is established. What should be the approach to send ...
Adnan's user avatar
  • 1,460
9 votes
3 answers
14k views

Generate unique api keys for user in node js application for access to your apis

how to generate API Keys for the user of your nodejs application on the basis of different parameters of the user in the database for giving access to our server endpoints.
Paras Patidar's user avatar
8 votes
3 answers
6k views

MongoDB error as setup Wizard ended prematurely, while installing it on windows 10

I have downloaded MongoDB from the official site as an .msi file and during installation it stops and freezes and after half an hour, and gives an error as the setup wizard ended prematurely. I have ...
GD- Ganesh Deshmukh's user avatar
7 votes
2 answers
2k views

Correct way of creating a realtime application with Cassandra

Right now I have a ec2 instance running Cassandra and a simple websocket server. I would like to know if this is the correct way to make a "real time" chat application. Is there anything I'm missing? ...
WHOATEMYNOODLES's user avatar
7 votes
2 answers
12k views

What is MySQL doing?? 100% disk utilization from boot

I have a large database on a Win10 machine, mysqld.exe does a lot of disk I/O, 100%, for hours and hours 100MB/s consistently - mostly writes - persists after numerous reboots. How can I find out what ...
Daniel's user avatar
  • 773
6 votes
2 answers
5k views

I want to connect openshift mongodb database from my local client tools

I have my premium openshift account I have all types of access in openshift I have ssh key & user's credentials I have MongoVUE & Robomongo & others client tools to open mongodb database. ...
Dr. Piyush Dholariya's user avatar
6 votes
2 answers
140 views

figure out a long term solution for both file sharing and distributing documents from classroom to all the students

Background: I am an highschool computer science teacher. My students uses Citrix as their means for sharing internal files. In order to access the files, they must be logged in using Citrix Receiver. ...
gordon sung's user avatar
5 votes
2 answers
8k views

Close mysql port : 3306 and make it local

When I'm trying to show the port that's opened in my server show to me the port : 3306 and this port for mysql database How can I close mysql port (3306) and make it just for local connections mean ...
Mr. zero's user avatar
  • 243
4 votes
3 answers
58 views

How data can be synchronized among multiple linux servers [closed]

I have basically 4 servers for running the same project. I want make changes in database from UI. What should I do so that all changes are reflected on all server so that all servers contain the ...
Lokesh Kumar's user avatar
4 votes
1 answer
7k views

ModbusTCP Server/Slave Implementation in Python (pymodbus)

I try to write a ModbusTCP server software connected wıth a database. I used pyModbus library for that task. That library has an Updating Server Example. By using that code, I wrote my code as : ''' ...
Şansal Birbaş's user avatar
4 votes
1 answer
842 views

DB backup in cron is creating a file with zero byte

I have set up a cron in my godaddy server for taking DB backup. For Testing purpose, I run the cron in every minute. The command is : mysqldump tuniv_results > /home/username/public_html/DB-VVS/...
Srim's user avatar
  • 547
3 votes
3 answers
1k views

How to build a server database for my application

I'm new to server side programming with a background in iOS. So I want to know where to start. Here I tried to list some specific questions: Can I just create a local database and practice on that? ...
Web Amateur's user avatar
3 votes
3 answers
6k views

How do I turn on query_cache on a Windows XAMPP Server?

In xampp/mysql/bin/my.ini Do I add? query_cache_size = 16777216 query_cache_type = 1 query_cache_limit = 1048576 I have tried the above and restarted mysql server but when I run this query: SHOW ...
user3312792's user avatar
  • 1,101
3 votes
1 answer
202 views

I cannot seem to connect my PHP page to my SQL test server and database

What I would like to happen is for a user to fill out a form and that information be sent to a database. I am using html and php in dreamweaver, and WAM with phpMyAdmin. I have tried everything and ...
Snowball_'s user avatar
  • 123
3 votes
2 answers
11k views

Connect to remote MySQL via Python

I have installed MySQL on a remote server. I also created some databases with some tables in them, all via SSH. I have created the following users: CREATE USER 'myname'@'localhost' IDENTIFIED BY '...
JNevens's user avatar
  • 11.6k
3 votes
1 answer
477 views

Postgresql server: Allow access to the remote connections within the private network, not external

Presently, I am editing configuration file of the Postgresql for allowing remote connections: >> sudo nano /etc/postgresql/14/main/pg_hba.conf #Allout or Universal connection: #To all allow ...
Mainland's user avatar
  • 4,420
3 votes
1 answer
3k views

Backend: remote vs local sql database

What is your position on having the (relational) database on the same machine as the application server if you want to have a scaleable backend which can handle around 200 simultaneous requests? I ...
user avatar
3 votes
2 answers
2k views

Whats a DBMS... Confused [closed]

I'm on a big doubt, Whats really a DBMS. Is it the Client who manages the database server? Or is it the Server... Is it Mysql Workbench the DBMS or is it the MYSQL Server. Please if you could help,...
Fabrizio Gonzalez's user avatar
3 votes
0 answers
114 views

Is this system an optimal solution to sync an app with a server in real time efficiently?

Problem I have an Android and iOS app, looking like a classic social network. I need to update UI in real time. Currently, I use a classic system of a client polling each second to a php script by ...
Jerem Lachkar's user avatar
3 votes
1 answer
1k views

Insert images to cassandra using python

I'm new in cassandra and python. I'm trying to insert images in a table in cassandra using python. I want to see the image I'm inserting and the same image after I retrive from the database. import ...
Israel Rodriguez's user avatar
3 votes
1 answer
234 views

Storing data needed to be retrieved in my mobile app

I have seen many examples retrieving data from websites to be used as contents of applications. Now I am developing my own app, I have my own contents to be delivered to my users, where am I supposed ...
Alex's user avatar
  • 891
2 votes
4 answers
5k views

How to fix 'Active: active (exited)' issue in Cassandra server?

I'm installing a new cassandra database server and want to run the same successfully. How to fix the exited state issue? This is for a new Ubuntu server. Active: active (exited) I want it to be ...
Gokul Chidambaram's user avatar
2 votes
2 answers
2k views

How to retrieve data from Firebase database without listeners?

Right now I'm developing an android app, and I just started to work with Firebase. My question is: How can I retrieve data from the firebase database, without use listeners ? In my game, I'm saving ...
Levi Omer's user avatar
  • 107
2 votes
5 answers
36k views

Network access was interrupted

The Access database just needs to be open and it will usually crash within the next 20-40mins, resulting in the following error message: Your network access was interrupted. To continue, close the ...
Magnus's user avatar
  • 360
2 votes
1 answer
869 views

Can QGIS server read projects from database

I have QGIS server working. The standard functionality is to add ?map=path/to/projectfile.qgs to the server URL. So you can dynamically switch between projects in your webapplication. Now I make my ...
Arendjan van der Neut's user avatar
2 votes
2 answers
5k views

Can't connect to local MySQL server in R

I am learning how to use MySQL in R with the package RMySQL: https://www.tutorialspoint.com/r/r_database.htm but when I try to connect to the DB provided in the example mysqlconnection = dbConnect(...
Xavier Prudent's user avatar
2 votes
1 answer
683 views

How do I shutdown Meteor Mongo?

I kind of know how to shutdown Mongo, not sure if its right. use admin db.shutDownServer() This had no effect with Meteor Mongo. FYI started learning how to use a computer recently, pardon the lack ...
MXD's user avatar
  • 45
2 votes
2 answers
135 views

Aqueduct: Bad state: No entity found for '_MyEntity'. Did you forget to create a 'ManagedContext'?

I'm getting started on a new project and want to use test driven development.This is my entity: import 'package:aqueduct/aqueduct.dart'; class MyEntity extends ManagedObject<_MyEntity> ...
Suragch's user avatar
  • 498k
2 votes
1 answer
1k views

Django: how to emulate a slow server?

The production server my work is pushed to performs significantly worse than my local development environment, where everything runs fast and smoothly, so I cannot figure out if any change I make may ...
dabadaba's user avatar
  • 9,262
2 votes
1 answer
7k views

replication between xampp localhost database and remote server database

I need to create replication between two different databases one is localhost database as the master and the second one is the remote server database as slave? I have a codeigniter web application ...
user avatar
2 votes
1 answer
65 views

Easiest server and database services available for deploying an application (AWS specifically)

I have written a real-time multiplayer game and currently writing its server in NodeJS. I want my game to have login, level up etc, so I need to have a database. This is the first time I am deploying ...
ozgeneral's user avatar
  • 6,411
2 votes
1 answer
613 views

How should the REST API look for updating a resource with server's datetime?

I am creating a database server with resources with 'lastAccessed' datetime field. This field must be updated with the server's time with every read, but not query. How should I design the REST API if ...
Efreeto's user avatar
  • 2,201
2 votes
1 answer
72 views

Server communication with database

I'm creating an online game and the client is going to be made using unity as well as the server and I'm wondering whether it's okay for the server to communicate with mysql database via PHP
Martin Lukas's user avatar
2 votes
1 answer
58 views

MySQL performance issues in my mind [closed]

First of all, I'm not a very experienced developer, I'm making mid-size apps in PHP, MySQL and Javascript. There is something though which is making it hard for me to design a MySQL InnoDB database ...
Radical_Activity's user avatar
2 votes
2 answers
6k views

best way to connect android app with desktop app?

I want to develop a system in which data is being shared between DESKTOP app and Android app. After searching I have found that I need a server in between them. But I can't figure out what the server ...
NiaziBro's user avatar
2 votes
1 answer
25 views

Connection refused when i create a new Serveur in PostreSQL

When i try the add a new serveur to my PostgreSQL on the pc in my university, i get an error : could not connect to server : Connection refused the server running on host "localhost" (::1) and ...
Elie Daher's user avatar
2 votes
1 answer
296 views

Transfering data between two rails servers

What I'm trying to do is to transfer my Company model that has a lot of associations, depots, products, users, owners, etc, to another database(server). I've tried cloning the company but it doesn't ...
Catalin Voineag's user avatar
2 votes
1 answer
264 views

Single sign on for high performance WebSocket game server?

I am developing a C# game server using WebSocket protocol (through WebSocketSharp). Currently, whenever a user log in to the game, I create a token and add it into a ConcurrentDictionary. Now that I ...
Luke Vo's user avatar
  • 19.2k
2 votes
1 answer
238 views

MySQL Import into Innodb table severely spikes at a certain point

I'm trying to migrate a 30GB database from one server to another. The short story is that at a certain point through the process, the amount of time it takes to import records severely increases as a ...
Steve H's user avatar
  • 31
2 votes
0 answers
79 views

xampp - extremely slow phpmyadmin via mysql server

I use a macbook PRO with an M1 processor. I downloaded xampp version 8.2.4-0 for OS X users. After installation I started the mysql server and opened "http://localhost/phpmyadmin". The page ...
GreenRockLee's user avatar
2 votes
0 answers
618 views

Strapi can't access admin page

STrapi page is working correctly for me on local host but when i hosted it on replit it gives these errors main.9c01de7f.js:2981 Refused to connect to 'http://localhost:1337/admin/project-type' ...
Maaz Saeed's user avatar
2 votes
0 answers
91 views

Connecting two node app servers to a single mongo db database

This is some sort of design problem facing in my company. We are building an online education platform , in this we got one interesting use case. We have admin site currently (one front end, one back-...
saivasanth528's user avatar
2 votes
0 answers
3k views

Is there any way to get all ookla server list and store this into a data base?

i wanted to insert all available ookla servers into my data base for the speed test purpose for my android application. But i am not getting any way to find out how to get this servers list and insert ...
anu5439's user avatar
  • 21
2 votes
0 answers
227 views

How to insert fraction symbols in database like ¼, ½ etc

I saved some long text in my database. That text also contains some fraction symbols like ¼, ½ etc. When I try to retrieve that text in my android app, no text appears and then I remove the fraction ...
Qazi Hassan's user avatar
2 votes
0 answers
1k views

confirm max_parallel_workers_per_gather (parallelism) is being utilized correctly

We have a 8 core ESXi. We have a few virtual servers on it, one of which is our database (virtual) server. We have 2 cores provisioned for that db server. I have set: set ...
mountainclimber11's user avatar
2 votes
1 answer
114 views

Whats better, make a loop reading php in android or make a loop in php reading a database?

i am making an application in android that has to read constantly a database hosted in my server, my question is, is better make a loop in android, reading the php document constantly or just read ...
Nicolás Angarita's user avatar
2 votes
0 answers
895 views

Java Websocket Server Global DB connection

I'm trying to develop a Websocket based application using Java. Now I have a question: how to "permanently" connect the server endpoint to the database? (embedded with Netbeans newest version is Derby)...
howToDeleteMyAccount's user avatar
2 votes
0 answers
403 views

Ports & Databases: Designing a game server architecture for many simultaneous live multiplayer games

I'm designing a framework for running synchronous multiplayer games. A game server needs to be able to create many instances of its designated game, according to some parameters. For starters, this ...
quantumpotato's user avatar
1 vote
2 answers
13k views

what is COB Environment? [closed]

I often come across terms like COB Server or COB Database. Can anyone please explain what is COB environment and how is it different from production or UAT environment.
Vinda's user avatar
  • 213

1
2 3 4 5
10