All Questions
491
questions
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/...
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 ...
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.
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 ...
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?
...
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 ...
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.
...
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. ...
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 ...
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 ...
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 :
'''
...
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/...
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?
...
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 ...
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 ...
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 '...
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 ...
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 ...
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,...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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(...
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 ...
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> ...
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 ...
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 ...
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 ...
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 ...
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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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' ...
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-...
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 ...
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 ...
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 ...
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 ...
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)...
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 ...
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.